Обсуждение: postgres_fdw connection string

Поиск
Список
Период
Сортировка

postgres_fdw connection string

От
Hans Ginzel
Дата:
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