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 Schema

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 like:

[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 )

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,