Thread: SHOW TABLES ?
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
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 >
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 > > >
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: >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. > > > >