Обсуждение: 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.
>
>
>
>