Re: Feature request: Connection string parsing for postgres_fdw

2020-12-27 Thread Eric Hanson
Whoa that's perfect! Thank you so much. On Thu, Dec 24, 2020 at 4:59 PM Ian Lawrence Barwick wrote: > 2020年12月23日(水) 22:05 Eric Hanson : > > > > I'm trying to store connection to postgres_fdw in the database I want > to be able to store the full breadth of connection styles and all the > diffe

Re: Feature request: Connection string parsing for postgres_fdw

2020-12-24 Thread Michael Paquier
On Fri, Dec 25, 2020 at 09:59:09AM +0900, Ian Lawrence Barwick wrote: > Basically a wrapper around PQconninfoParse(), I've had the code knocking > around > for a while now and finally got round to packaging it into an > extension [1]. It's > on my todo list to submit a patch based on this to core,

Re: Feature request: Connection string parsing for postgres_fdw

2020-12-24 Thread Ian Lawrence Barwick
2020年12月23日(水) 22:05 Eric Hanson : > > I'm trying to store connection to postgres_fdw in the database I want to be > able to store the full breadth of connection styles and all the different > types of connections that libpq supports. But having some troubles. > > Postgres_fdw wants options pas

Re: Feature request: Connection string parsing for postgres_fdw

2020-12-24 Thread Ashutosh Bapat
On Wed, Dec 23, 2020 at 7:42 PM Eric Hanson wrote: > > > > On Wed, Dec 23, 2020 at 5:39 AM Ashutosh Bapat > wrote: >> >> https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-PARAMKEYWORDS >> lists the parameters that postgres_fdw accepts. "dbname" can be more >> than just dbname. See >> h

Re: Feature request: Connection string parsing for postgres_fdw

2020-12-23 Thread Eric Hanson
On Wed, Dec 23, 2020 at 5:39 AM Ashutosh Bapat wrote: > https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-PARAMKEYWORDS > lists the parameters that postgres_fdw accepts. "dbname" can be more > than just dbname. See > https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-CONNSTRING

Re: Feature request: Connection string parsing for postgres_fdw

2020-12-23 Thread Ashutosh Bapat
On Wed, Dec 23, 2020 at 6:35 PM Eric Hanson wrote: > > I'm trying to store connection to postgres_fdw in the database I want to be > able to store the full breadth of connection styles and all the different > types of connections that libpq supports. But having some troubles. > > Postgres_fdw

Feature request: Connection string parsing for postgres_fdw

2020-12-23 Thread Eric Hanson
I'm trying to store connection to postgres_fdw in the database I want to be able to store the full breadth of connection styles and all the different types of connections that libpq supports. But having some troubles. Postgres_fdw wants options passed into CREATE SERVER, all broken out into sepa