Sure Dave, will work on this issue. Dinesh
-- *Dinesh Kumar* Software Engineer Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> On Fri, Aug 2, 2013 at 11:00 PM, Dave Page <dp...@pgadmin.org> wrote: > 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 >
