Re: SHOW TABLES ? - Mailing list pgsql-general

From pgmoscatt
Subject Re: SHOW TABLES ?
Date
Msg-id 1076141002.2444.0.camel@localhost
Whole thread Raw
In response to Re: SHOW TABLES ?  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-general
Thanks Pavel.

Pete


On Sat, 2004-02-07 at 17:55, Pavel Stehule wrote:
> 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: Pavel Stehule
Date:
Subject: Re: SHOW TABLES ?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Can anyone recommend accounting software using PGSQL?