Thread: database URL

TWIMC,
 I have been trying to determine the url for a postgres database and was
wondering if someone be able to provide me with this info.
I writting java code to interface with the postgres environement and
have had no luck in finding the db URL info.

TIA

Robert C. LaPreze
--

___________________________________________________
                           ______
  Robert C. LaPreze      /  ___/\
  Solutions Architect     /___  /\/______
  rlapreze@sgi.com    /_____/ //  ___/\
  http://www.sgi.com    \_____\//  /  /\/______
  Tele: (410)489-9148           /_____/ //_  __/\
  Fax:  (240)352-2373           \_____\/_\/ /__\/
  Cell: (443)255-9608                 /_____/\
  Vnet:      933-1692                 \_____\/

On Fri, Mar 16, 2001 at 01:11:35PM -0500, Robert LaPreze wrote:
>  I have been trying to determine the url for a postgres database and was
> wondering if someone be able to provide me with this info.
> I writting java code to interface with the postgres environement and
> have had no luck in finding the db URL info.

If memory serves correctly, the url is constructed as:

jdbc:<databse>:<vendor-specific-urls>

For postgress, this takes the more specific form of:

jdbc:postgresql://<machine-name>:<port>/<database-name>

And finally as an example, this string will access the database called
'foo' on the local machine from a postmaster started with default
parameters.

jdbc:postgresl://localhost:5432/foo