| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | pgmoscatt <pgmoscatt(at)optushome(dot)com(dot)au> |
| Cc: | PostGreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SHOW TABLES ? |
| Date: | 2004-02-07 07:55:27 |
| Message-ID: | Pine.LNX.4.44.0402070855050.10599-100000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgmoscatt | 2004-02-07 08:03:22 | Re: SHOW TABLES ? |
| Previous Message | Chris Travers | 2004-02-07 07:46:05 | Can anyone recommend accounting software using PGSQL? |