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

Re: basic DB questions

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: basic DB questions
Date: 2008-10-16 18:29:31
Message-ID: 264855a00810161129k124b8840q945b4edff56edf9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Oct 16, 2008 at 2:20 PM, Isabella Ghiurea
<isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

pgsql-novice by date

Next:From: Steve TDate: 2008-10-16 19:04:33
Subject: Re: Max OID
Previous:From: Andreas KretschmerDate: 2008-10-16 18:24:35
Subject: Re: basic DB questions

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