Horton

Re: Should psql support URI syntax?

Joshua D. Drake <jd@commandprompt.com>

View thread View on postgr.es
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Adrian von Bidder <avbidder@fortytwo.ch>, pgsql-hackers@postgresql.org
Date: 2011-04-06T18:31:38Z
Lists: pgsql-hackers 
Hello,

O.k., the basic JDBC syntax is:

jdbc:<driver>://<host>[:<port>]/<database_name> 

Where driver is the actual database such as postgresql or db2.

I am thinking something like:

postgres:ssl://localhost:5432/template

Many drivers support an extended syntax like:

postgres:ssl://localhost:5432/template1/?username=jd&password=foobar&ssl=true

But I don't know if we want to go there.

Sincerely,

Joshua D. Drake
-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt