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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Steve T 2008-10-16 19:04:33 Re: Max OID
Previous Message Andreas Kretschmer 2008-10-16 18:24:35 Re: basic DB questions