Date sent: Sun, 03 Aug 2003 21:44:04 +0200
From: Wolfgang Draxinger <wdraxinger@darkstargames.de>
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Migration from MySQL, some difficulties with
DESCRIBE and SHOW
I'm unfamiliar with mysql,
but I think what you are looking for in the psql client are these commands
SHOW TABLES:
\d{t|i|s|v}... list tables/indexes/sequences/views
\d will give a list of all of these objects
\dt will give a list of only tables
mfx=# \d
List of relations
Name | Type | Owner
------------------+----------+---------------
accent | table | Administrator
accenttype | table | Administrator
actor | table | Administrator
actor_id_seq | sequence | Administrator
actoraudio | view | Administrator
audio | table | Administrator
audiotype | table | Administrator
(7 rows)
DESCRIBE: (I'm assuming this gives a listing of a table's structure)
\d tablename
mfx=# \d accent
Table "accent"
Column | Type | Modifiers
------------+-------------------+-----------
accenttype | character varying | not null
id | integer | not null
Primary key: accent_pkey
Triggers: RI_ConstraintTrigger_1673596,
RI_ConstraintTrigger_1673602
Hope this helps
Paul Butler
> 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