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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
