Thread: [SOLVED] RE: Foreign Servers

[SOLVED] RE: Foreign Servers

From
David Greco
Date:

Found it, they appear under the Foreign Data Wrapper in the object browser

 

 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of David Greco
Sent: Thursday, September 27, 2012 9:01 AM
To: PgAdmin Support (pgadmin-support@postgresql.org)
Subject: [pgadmin-support] Foreign Servers

 

Where should Foreign Servers appear in the Object Browser?  I have two foreign servers defined, confirmed by querying information_schema.foreign_servers, but the Object Browser doesn’t show them in the schema they are defined, or any other place that I can see. I have Foreign Servers checked in Options->Browser->Display. I do see the foreign tables and foreign data wrappers.

 

 

 

 

Re: [SOLVED] RE: Foreign Servers

From
Guillaume Lelarge
Date:
On Thu, 2012-09-27 at 13:22 +0000, David Greco wrote:
> Found it, they appear under the Foreign Data Wrapper in the object browser
> 

Exactly. And user mappings are under foreign servers.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com