| From: | "Eric Johnson" <ej(at)ejinnovations(dot)com> |
|---|---|
| To: | "Wolfgang Draxinger" <wdraxinger(at)darkstargames(dot)de>, <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Migration from MySQL, some difficulties with DESCRIBE and SHOW |
| Date: | 2003-08-03 20:32:47 |
| Message-ID: | 012101c359fe$698e3b00$1a08090a@MINIDEV |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Try:
\d tablename for DESCRIBE functionality
\dt for SHOW TABLES functionality.
Hope that helps,
Eric
----- Original Message -----
From: "Wolfgang Draxinger" <wdraxinger(at)darkstargames(dot)de>
To: <pgsql-novice(at)postgresql(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | paul butler | 2003-08-04 07:13:00 | Re: Migration from MySQL, some difficulties with DESCRIBE and SHOW |
| Previous Message | Wolfgang Draxinger | 2003-08-03 19:44:04 | Migration from MySQL, some difficulties with DESCRIBE and SHOW |