Re: Migration from MySQL, some difficulties with DESCRIBE and SHOW

Try:

\d tablename     for DESCRIBE functionality
\dt                    for SHOW TABLES functionality.


Hope that helps,
Eric


----- Original Message -----
From: "Wolfgang Draxinger" <wdraxinger@darkstargames.de>
To: <pgsql-novice@postgresql.org>
Sent: Sunday, August 03, 2003 2:44 PM
Subject: [NOVICE] Migration from MySQL, some difficulties with DESCRIBE and
SHOW


> I just migrated to PostgreSQL since this offers a few features I needes
> ugently, especially subqueries. However I got to stuck with DESCRIBE and
> SHOW commands. Are those not avaliable, or have they some special
behaviour?
> When trying a SHOW TABLES; I just get an error.
>
> Wolfgang
> --
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>