From: | "Machiel Richards" <machielr(at)rdc(dot)co(dot)za> |
---|---|
To: | "'adam_pgsql'" <adam_pgsql(at)witneyweb(dot)org> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Changing databases / schemas |
Date: | 2010-02-22 12:16:13 |
Message-ID: | 021401cab3b8$eb4bfae0$c1e3f0a0$@co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thank you very much, this helps a lot.
Machiel Richards
MySQL DBA
Relational Database Consulting
-----Original Message-----
From: adam_pgsql [mailto:adam_pgsql(at)witneyweb(dot)org]
Sent: 22 February 2010 2:14 PM
To: Machiel Richards
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Changing databases / schemas
> . In MySQL for example you can use "use <database>" and then
change between databases which you want to access currently.
> o Is there something similar in Postgres or do you need to disconnect
and reconnect to the next database everytime you want to change the current
working DB?
To connect to a database from psql:
\c <database>
> . Once connected to a database , how can I see a list of schemas
and in turn a list of tables that are currently available and also how do I
see the table info (i.e describe in other dbms systems)
For a list of schemas (schemata?):
\dn
For a list of tables:
\dt <schema>.*
For a description of the table:
\d <schema>.<tablename>
For a full list of commands use:
\?
cheers
adam
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Maggi | 2010-02-22 13:25:00 | which mailing list for bindings writers |
Previous Message | adam_pgsql | 2010-02-22 12:14:18 | Re: Changing databases / schemas |