Thread: CREATE SERVER - what is this?

CREATE SERVER - what is this?

From
Richard Broersma
Date:
I noticed a few new SQL references in the manual:

CREATE SERVER
CREATE FOREIGN DATA WRAPPER,
CREATE USER MAPPING

Is this similar to DBI-Link?

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


Re: CREATE SERVER - what is this?

From
Guillaume Lelarge
Date:
Le mardi 24 novembre 2009 à 16:45:27, Richard Broersma a écrit :
> I noticed a few new SQL references in the manual:
>
> CREATE SERVER
> CREATE FOREIGN DATA WRAPPER,
> CREATE USER MAPPING
>
> Is this similar to DBI-Link?
>

They appear on the 8.4 release. They were added to support the use of SQL/MED
compliant FOREIGN DATA WRAPPER, SERVER, and USER MAPPING as method to supply
dblink connect parameters. dblink can already use these informations AFAIK.


--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com