Re: Should psql support URI syntax?

On sön, 2011-04-03 at 12:41 -0400, Tom Lane wrote:
> 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).

Btw., there is also

$dbh = DBI->connect("dbi:Pg:dbname=$dbname", '', '', {AutoCommit => 0});

using a kind-of URI notation.