| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: how to list all tables in a database |
| Date: | 2006-01-09 12:48:21 |
| Message-ID: | 20060109124821.GG26237@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
am 09.01.2006, um 12:37:19 -0500 mailte Joao Miguel Ferreira folgendes:
> Hello all,
>
> this is my first question... I'm really new to PG.
>
> How do I get a list of all tables in a database ?
Depends. In psql you can type '\t' (without ') to see all tables. Hint:
read the welcome-message, when you start psql. *wink*
If you want to see the complete underlaying SQL, you should start psql
with the option '-E'. For more info: man psql *wink*
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Tucknott | 2006-01-09 13:12:13 | Triggers and speed - 7.4.5 / 8.0.3 |
| Previous Message | Sean Davis | 2006-01-09 12:47:11 | Re: how to list all tables in a database |