Re: Foreign table column options in pgAdmin 4

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Foreign table column options in pgAdmin 4
Дата
Msg-id CA+OCxoxuFWUsNqN7-1_YMkcSDt1G8axgOAZy=6pGzCAnnxPSXg@mail.gmail.com
обсуждение исходный текст
Ответ на Foreign table column options in pgAdmin 4  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgadmin-support
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



В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Error displaying bytea field with pgAdmin 4
Следующее
От: Albe Laurenz
Дата:
Сообщение: Problem displaying intervals and timestamps with pgAdmin 4