Skip site navigation (1) Skip section navigation (2)

switching databases

From: "Adler, Stephen" <adler(at)bnl(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: switching databases
Date: 2002-11-30 17:05:31
Message-ID: 1038675931.11026.8.camel@newadler.phy.bnl.gov (view raw or flat)
Thread:
Lists: pgsql-novice
Is there a way to switch databases within psql like there is
in mysql using the 'use' command?

I have two databases, one named test, the other name data, if
I do 'psql test' I'm connected to the test database, to connect
to the data database, I have to quite psql then run the command
'psql data'. It would be nice not to have to quit out of psql.

Thanks. Steve.


In response to

Responses

pgsql-novice by date

Next:From: Adler, StephenDate: 2002-11-30 17:13:50
Subject: enum
Previous:From: Ewald GeschwindeDate: 2002-11-30 17:02:06
Subject: Re: switching databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group