postgres_fdw connection string - Mailing list pgsql-novice

From Hans Ginzel
Subject postgres_fdw connection string
Date
Msg-id 20150819113057.GA96041@artax.karlin.mff.cuni.cz
Whole thread Raw
List pgsql-novice
Hello!

How to specify connection string for Postgres_FDW, please?

CREATE SERVER pg_srv FOREIGN DATA WRAPPER Postgres_FDW OPTIONS (dbserver '//host-name/db');
psql: ERROR:  invalid option "dbserver"

For Oracle it works
CREATE SERVER pspdev FOREIGN DATA WRAPPER Oracle_FDW OPTIONS (dbserver '//host-name:port/db');

I prefer to specify connection string to separate connection options.
http://www.postgresql.org/docs/9.4/static/postgres-fdw.html
http://www.postgresql.org/docs/9.4/static/libpq-connect.html#LIBPQ-CONNSTRING

Regards,
Hans


pgsql-novice by date:

Previous
From: venkateshwaran S
Date:
Subject: Debugging Postgresql 9.3 with Eclipse CDT and GDB
Next
From: Tom Lane
Date:
Subject: Re: Debugging Postgresql 9.3 with Eclipse CDT and GDB