Thread: basic DB questions
Hi, I'm trying to learn PG, here are my very basic questions, -how to switch between db's in a Pg cluster ( with 2 aka : db1 & db2) , as user postrges using;'psql - what will always be the the default db when first I call psql thank you, Isabella
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> schrieb: > > Hi, > I'm trying to learn PG, here are my very basic questions, > -how to switch between db's in a Pg cluster ( with 2 aka : db1 & db2) , > as user postrges using;'psql \c <other_db> > - what will always be the the default db when first I call psql without a db? A db called <your_username> Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
On Thu, Oct 16, 2008 at 2:20 PM, Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> wrote: > > Hi, > I'm trying to learn PG, here are my very basic questions, > -how to switch between db's in a Pg cluster ( with 2 aka : db1 & db2) , as > user postrges using;'psql \connect db1 \connect db2 > - what will always be the the default db when first I call psql Depends on the user. As postgres, the database will be postgres. > thank you, > Isabella > > -- > Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-novice >