| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SHOW TABLES ? |
| Date: | 2004-02-07 09:40:22 |
| Message-ID: | 20040207094022.A32468@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 07/02/2004 07:41 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 ?
Assuming you mean how do list tables in the psql client
\d
Try man psql for more details.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | W. van den Akker | 2004-02-07 10:29:32 | Extract transaction logging |
| Previous Message | Shridhar Daithankar | 2004-02-07 09:32:07 | Re: Can anyone recommend accounting software using PGSQL? |