Dinesh, can you look at this please? Thanks. On Thu, Aug 1, 2013 at 11:40 PM, Bill MacArthur <webmas...@dhs-club.com> wrote: > Hello, > > I am guessing that somebody has already reported this, but in case not, here > goes. I am using version 1.16.1 on windows XP against a Postgres version > 9.2.4 server. The wrapper options for a foreign data wrappers table get > really goobered up inside of pgadmin. > I have a foreign table that is defined by \d as: > > network=# \d test.grpmgt > Foreign table "test.grpmgt" > Column | Type | Modifiers | FDW Options > --------+---------+-----------+------------- > id | integer | | > uptime | integer | | > paid | boolean | | > Server: file_server > FDW Options: (format 'text', filename '/tmp/grpmgt', delimiter ',', "null" > E'\\\\N') > > > However, the same object is reported in pgadmin as: > > CREATE FOREIGN TABLE work.grpmgt > (id integer , > upline integer , > paid boolean ) > SERVER file_server > OPTIONS (format 'text,filename=/tmp/grpmgt,', elimiter '', , '', ull > '\\\\N"'); > > > As you can well imagine, that SQL statement cannot recreate that table. It > breaks down in the OPTIONS. > > Pgadmin is a wonderful tool and this aberration is of minimal consequence to > me, but I figure that the least I could do to help make it better would be > to report this. > > Thank you much. > Bill MacArthur > > > -- > 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
