Re: Should psql support URI syntax?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Adrian von Bidder <avbidder@fortytwo.ch>, pgsql-hackers@postgresql.org
Date: 2011-04-03T16:41:56Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> 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

True, but the need for those %20's is annoying.  I tend to agree with
the suggestion that adopting the JDBC syntax would be the way to go,
assuming that we can use it 100%-as-is (any incompatibility defeats
the purpose).

			regards, tom lane