Postgres Pro
Downloads
Home   >   mailing lists

Re: how to list all tables in a database - Mailing list pgsql-novice

From Brad Nicholson
Subject Re: how to list all tables in a database
Date
Msg-id 43C282AC.5020207@ca.afilias.info
Whole thread Raw
In response to how to list all tables in a database  (Joao Miguel Ferreira <jmf@estg.ipvc.pt>)
List pgsql-novice
Tree view 
Joao Miguel Ferreira wrote:

>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 ?
>
>Is there an SQL command for this ?
>
>thx
>
>jmf
>
>
>
In the psql terminal

\dt


--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: how to recall the initial definition (CREATE TABLE) of a table ?
Next
From: Jaime Casanova
Date:
Subject: Re: how to recall the initial definition (CREATE TABLE)