Foreign table column options in pgAdmin 4

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

Responses

Browse pgadmin-support by date

  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