By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,822 Members | 1,055 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,822 IT Pros & Developers. It's quick & easy.

SHOW TABLES ?

P: n/a
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

Nov 22 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
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

Nov 22 '05 #2

P: n/a
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

Nov 22 '05 #3

P: n/a

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

Nov 22 '05 #4

P: n/a
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

Nov 22 '05 #5

P: n/a
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

Nov 22 '05 #6

P: n/a
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

Nov 22 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.