SHOW TABLES ?

[pgmoscatt]

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

[Pavel Stehule]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[pgmoscatt]

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Paul Thomas]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[W. van den Akker]

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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Peter Eisentraut]

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.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[W. van den Akker]

Well, I think I go to translate....... and have already POEdit downloaded...
Peter Eisentraut wrote:

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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html