Re: Foreign table column options in pgAdmin 4

Thanks - issue #1351 created.

On Mon, Jun 13, 2016 at 9:47 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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(at)postgresql(dot)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