Foreign table column options in pgAdmin 4
От | Albe Laurenz |
---|---|
Тема | Foreign table column options in pgAdmin 4 |
Дата | |
Msg-id | A737B7A37273E048B164557ADEF4A58B5385EFD8@ntex2010i.host.magwien.gv.at обсуждение исходный текст |
Ответы |
Re: Foreign table column options in pgAdmin 4
|
Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: