Re: Should psql support URI syntax? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Should psql support URI syntax?
Date
Msg-id 1301823154.5146.2.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Should psql support URI syntax?  (Adrian von Bidder <avbidder@fortytwo.ch>)
Responses Re: Should psql support URI syntax?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On fre, 2011-04-01 at 09:12 +0200, Adrian von Bidder wrote:
> Since URI stings are popular, it might really make sense if pg could 
> recommend a preferred form of postgres URI strings (and obviously
> implement it in libpq).  For the non-libpq APIs (there's at least 
> http://python.projects.postgresql.org/, don't know about others), it
> would still be just a recommendation that they could follow or not
> follow, so the situation wouldn't change too much from today, I fear.

Well, there isn't any requirement that URIs be

prot://hostname:port/something

They just have to be

prot:something

So you could just turn the existing conninfo syntax into a URI by doing
something like

postgresql:dbname=foo%20hostname=bar



pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: FDW state from plan time
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: psql 9.1 alpha5: connection pointer is NULL