Re: SHOW TABLES ? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: SHOW TABLES ?
Date
Msg-id Pine.LNX.4.44.0402070855050.10599-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to SHOW TABLES ?  (pgmoscatt <pgmoscatt@optushome.com.au>)
Responses Re: SHOW TABLES ?
List pgsql-general
Hello

use metacmd \dt

Regards
Pavel


On Sat, 7 Feb 2004, pgmoscatt wrote:

> I have just moved over to PostGres after using MySQL.
>
> In MySQL I could issue the command SHOW TABLES within a database to show
> what tables are within.
>
> I tried to do this with PostGres and I get the following error message:
>
> Option 'tables' is not recognized
>
> How do I display the tables within a database ?
>
> Pete
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>


pgsql-general by date:

Previous
From: "Chris Travers"
Date:
Subject: Can anyone recommend accounting software using PGSQL?
Next
From: pgmoscatt
Date:
Subject: Re: SHOW TABLES ?