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

Hello

use metacmd \dt

Regards
Pavel


On Sat, 7 Feb 2004, pgmoscatt wrote:
[color=blue]
> 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
>[/color]


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

Thanks Pavel.

Pete


On Sat, 2004-02-07 at 17:55, Pavel Stehule wrote:[color=blue]
> Hello
>
> use metacmd \dt
>
> Regards
> Pavel
>
>
> On Sat, 7 Feb 2004, pgmoscatt wrote:
>[color=green]
> > 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
> >[/color]
>[/color]


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

On 07/02/2004 07:41 pgmoscatt wrote:[color=blue]
> 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 ?[/color]

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

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

W. van den Akker wrote:[color=blue]
> Is it somehow possible to extract the transaction logging?[/color]

No.
[color=blue]
> Secondly, how can I determine which user is locking a record?[/color]

Use the system table pg_locks.
[color=blue]
> How can I present the errormessages in 'Dutch' to the users.[/color]

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

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


Peter Eisentraut wrote:
[color=blue]
>W. van den Akker wrote:
>
>[color=green]
>>Is it somehow possible to extract the transaction logging?
>>
>>[/color]
>
>No.
>
>
>[color=green]
>>Secondly, how can I determine which user is locking a record?
>>
>>[/color]
>
>Use the system table pg_locks.
>
>
>[color=green]
>>How can I present the errormessages in 'Dutch' to the users.
>>
>>[/color]
>
>You would need to write such a translation first. See
>http://developer.postgresql.org/~petere/nlsinfo/ to get started.
>
>
>
>[/color]

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

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