Обсуждение: 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