SHOW TABLES ?

Hello

use metacmd \dt

Regards
Pavel

On Sat, 7 Feb 2004, pgmoscatt wrote:

Thanks Pavel.

Pete

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

Hi,

Is it somehow possible to extract the transaction logging?
Once a day I want to get a report with:
- the insert,delete,update transactions;
- who (user) did the transaction;
- time and date of the transaction;

Secondly, how can I determine which user is locking a record?
Sometimes a user left his dialogbox open on an update transaction.
I want users who also wants to update that record, get a message
"record locked by .....(user)"

And last...
How can I present the errormessages in 'Dutch' to the users.

TIA

Willem

W. van den Akker wrote:

Is it somehow possible to extract the transaction logging?

No.

Secondly, how can I determine which user is locking a record?

Use the system table pg_locks.

How can I present the errormessages in 'Dutch' to the users.

You would need to write such a translation first. See
http://developer.postgresql.org/~petere/nlsinfo/ to get started.

Well, I think I go to translate....... and have already POEdit downloaded...

Peter Eisentraut wrote: