Re: [GENERAL] FDWs, foreign servers and user mappings

2012-03-08 Thread Guillaume Lelarge
On Thu, 2012-03-08 at 10:04 -0500, Joe Abbate wrote: > On 03/08/2012 12:06 AM, Shigeru Hanada wrote: > > I think that makes, and will make sense. Because SQL/MED standard > > mentions about schema for only foreign table in "4.12 SQL-schemas" section. > > > > FYI, pgAdmin III shows them as a tree

Re: [GENERAL] FDWs, foreign servers and user mappings

2012-03-08 Thread Joe Abbate
On 03/08/2012 12:06 AM, Shigeru Hanada wrote: > I think that makes, and will make sense. Because SQL/MED standard > mentions about schema for only foreign table in "4.12 SQL-schemas" section. > > FYI, pgAdmin III shows them as a tree like: > > Database > FDW > Server > User Mapping >

Re: [GENERAL] FDWs, foreign servers and user mappings

2012-03-07 Thread Shigeru Hanada
(2012/03/08 6:16), Joe Abbate wrote: > Does that make sense? And if so, will it make sense in the future > (considering potential FDW developments)? I think that makes, and will make sense. Because SQL/MED standard mentions about schema for only foreign table in "4.12 SQL-schemas" section. FYI,

[GENERAL] FDWs, foreign servers and user mappings

2012-03-07 Thread Joe Abbate
Hi, We've been discussing the subject in the pyrseas-general ML, but I think it would be beneficial to get feedback from a broader audience. The Pyrseas dbtoyaml utility outputs the objects in YAML, which ends up looking like a tree (see http://pyrseas.readthedocs.org/en/latest/dbtoyaml.html ) an