Re: Get all names of tables in a database

From: "Poul L(dot) Christiansen" <plc(at)faroenet(dot)fo>
To: Thomas Weholt <Thomas(at)cintra(dot)no>
Cc: "'pgsql-novice(at)hub(dot)org'" <pgsql-novice(at)hub(dot)org>
Subject: Re: Get all names of tables in a database
Date: 2000-06-27 10:56:23
Message-ID: 39588856.70838D7F@faroenet.fo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Poul L. Christiansen 2000-06-27 11:06:53 Re: Get all names of tables in a database
Previous Message Martin Maney 2000-06-27 05:11:32 What's the point of multiple databases?