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 |
+------------------------------+---------------------------------------------+