PreviousNextTracker indexSee it online !

(207/212) 544 - Updated edit mode for SQL of PostgreSQL flavour

I propse attached mode file for PostgreSQL. It is an update on the created according to [request 301](https://sourceforge.net/p/jedit/feature-requests/301/) reflecting version 10.1 of PostgreSQL. It also contains queries to the catalog of the database to get a much simpler access to a good deal of the keywords.
I am not sure whether it make sense to have modes for the various versions of the database. I assume (and feel to be true with respect to 10.1 compared to 9.2) that keywords and of more recent versions are supersets of previous versions.

Submitted thiemo - 2018-02-10 20:08:21.966000 Assigned kerik-sf
Priority 5 Labels PostgreSQL mode
Status open Group none
Resolution None

Comments

2018-02-11 16:43:12.504000
thiemo

Sorry, the attached file is broken a bit. The function list contains only a small subset (what was fetched in the first fetch of dbeaver). I will cough up another one, but also including modules.

2018-02-11 16:43:31.907000
thiemo

- Attachments has changed:

Diff:

~~~~

--- old
+++ new
@@ -1 +0,0 @@
-pg-sql.xml (43.6 kB; text/xml)

~~~~

2018-02-11 23:05:42.339000
thiemo

improved file attached

pg-sql.xml (160.6Kio)

2018-02-12 21:17:56.127000
thiemo

- Attachments has changed:

Diff:

~~~~

--- old
+++ new
@@ -0,0 +1 @@
+pg-sql.xml (164.5 kB; text/xml)

~~~~

2018-02-12 21:17:56.547000
thiemo

Another version where I put RETURN to the others category even though it is not a PostgreSQL keyword.