Horton

Re: Get all names of tables in a database

Poul L. Christiansen <plc@faroenet.fo>

View thread View on postgr.es
From: "Poul L. Christiansen" <plc@faroenet.fo>
To: Thomas Weholt <Thomas@cintra.no>
Cc: "'pgsql-novice@hub.org'" <pgsql-novice@hub.org>
Date: 2000-06-27T10:56:23Z
Lists: pgsql-novice 
1. Log into the database "psql databasename"
2. just write "\dt" to list the tables

And write "\h" and "\?" to see all the commands.

Thomas Weholt wrote:

> Hi,
>
> How can I get the names of all the tables in a database?
>
> Thomas