[SQL] missing Postgres data types

[basaran]

• Sublime Version: 3.2
• OS Version: Linux

CREATE TABLE IF NOT EXISTS public.dropzone_details
(
    id uuid NOT NULL DEFAULT uuid_generate_v4(),
    name text COLLATE pg_catalog."default",
    doc jsonb,
    poc json,
    size integer,
    CONSTRAINT id_name_uix UNIQUE (id, name)
)

Postgresql has some new data types introduced since version 9.5. It appears some of them are missing in SQL.sublime-syntax.

These data types should be added to SQL.sublime-syntax:

uuid
jsonb
json
xml
pg_snapshot
pg_lsn
txid_snapshot

Reference: https://www.postgresql.org/docs/13/datatype.html

[jrappen]

@basaran Maybe you could add this feedback to the current work on #3046 and check if that PR fixes all issues on your side?

[michaelblyons]

Postgres isn't (yet) a part of #3046. Someone could add an extra extended file and start adding one, though. A handful of data types would be an easy place to start.

[jrappen]

From my understanding @keith-hall is still working on it, so now would be a good time to add this to the TODOs there I guess.

[jrappen]

Mostly addressed by #3046 now.

[deathaxe]

Note: Postgre is still incomplete right after merging PR #3046.