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