Re: FDWs, foreign servers and user mappings

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Joe Abbate <jma(at)freedomcircle(dot)com>
Cc: Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: FDWs, foreign servers and user mappings
Date: 2012-03-08 15:41:22
Message-ID: 1331221282.2322.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:
> >
> > Database
> > FDW
> > Server
> > User Mapping
> > Schema
> > Foreign Table
>
> Thanks. Incidentally, what version of pgAdmin shows that? I didn't see
> it in 1.14.0.
>

It is in 1.14, but you probably don't have enabled them to be displayed.
See menu File/Options, and then in the Display tab.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2012-03-08 15:52:41 Re: How to erase transaction logs on PostgreSQL
Previous Message dennis jenkins 2012-03-08 15:23:04 Re: Synchronous replication + Fusion-io = waste of money OR significant performance boost? (compared to normal SATA-based SSD-disks)?