Thread: Foreign table column options in pgAdmin 4
I am running pgAdmin 4 1.0-beta1 on Windows 7. This is the foreign table as displayed with psql: test=> \d typetest1 Foreign table "laurenz.typetest1"Column | Type | Modifiers | FDW Options --------+--------------------------+-----------+-------------id | integer | not null | (key 'yes')c | character(10) | |nc | character(10) | |vc | character varying(10) | |nvc | character varying(10) | |lc | text | |r | bytea | |u | uuid | |lb | bytea | |lr | bytea | |b | boolean | |num | numeric(7,5) | |fl | double precision | |db | double precision | |d | date | |ts | timestamp with time zone | |ids | interval | |iym | interval | | Server: oracle FDW Options: ("table" 'TYPETEST1') pgAdmin 4 does not show the column options (in this case "key") in the SQL script, in the "Properties..." dialog or in the "Properties" view. That is a bug, especially in the case of the SQL script, as the SQL displayed will not create the same object. Yours, Laurenz Albe
Thanks - issue #1351 created. On Mon, Jun 13, 2016 at 9:47 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote: > I am running pgAdmin 4 1.0-beta1 on Windows 7. > > This is the foreign table as displayed with psql: > > test=> \d typetest1 > Foreign table "laurenz.typetest1" > Column | Type | Modifiers | FDW Options > --------+--------------------------+-----------+------------- > id | integer | not null | (key 'yes') > c | character(10) | | > nc | character(10) | | > vc | character varying(10) | | > nvc | character varying(10) | | > lc | text | | > r | bytea | | > u | uuid | | > lb | bytea | | > lr | bytea | | > b | boolean | | > num | numeric(7,5) | | > fl | double precision | | > db | double precision | | > d | date | | > ts | timestamp with time zone | | > ids | interval | | > iym | interval | | > Server: oracle > FDW Options: ("table" 'TYPETEST1') > > pgAdmin 4 does not show the column options (in this case "key") in the SQL script, > in the "Properties..." dialog or in the "Properties" view. > > That is a bug, especially in the case of the SQL script, as the SQL displayed will > not create the same object. > > Yours, > Laurenz Albe > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company