From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Foreign table column options in pgAdmin 4 |
Date: | 2016-06-13 08:47:56 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B5385EFD8@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2016-06-13 08:51:00 | Error displaying bytea field with pgAdmin 4 |
Previous Message | Dave Page | 2016-06-11 17:24:11 | Re: pgadmin4 and Python3 |