| From: | Hans Ginzel <hans(at)matfyz(dot)cz> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | postgres_fdw connection string |
| Date: | 2015-08-19 11:30:58 |
| Message-ID: | 20150819113057.GA96041@artax.karlin.mff.cuni.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-08-19 13:46:47 | Re: Debugging Postgresql 9.3 with Eclipse CDT and GDB |
| Previous Message | venkateshwaran S | 2015-08-19 09:15:23 | Debugging Postgresql 9.3 with Eclipse CDT and GDB |