Re: how to list all tables in a database

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to list all tables in a database
Date: 2006-01-09 15:35:08
Message-ID: 43C282AC.5020207@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jaime Casanova 2006-01-09 15:38:06 Re: how to recall the initial definition (CREATE TABLE)
Previous Message Sean Davis 2006-01-09 14:08:53 Re: how to recall the initial definition (CREATE TABLE)