From: | "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com> |
---|---|
To: | "Kevin Waterson" <kevin(at)oceania(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org |
Subject: | Re: DESCRIBE eqivalent |
Date: | 2003-01-13 20:28:16 |
Message-ID: | OF59C977B3.9BBD1960-ON86256CAD.00702FC7@ipaper.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
you can use EXPLAIN or EXPLAIN ANALYSE (i think this is only available in
v7.2 and up).
explain select * from table_name;
regards,
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474
"Kevin Waterson" <kevin(at)oceania(dot)net>
Sent by: pgsql-novice-owner(at)postgresql(dot)org
01/13/2003 02:27 PM
To: pgsql-novice(at)postgresql(dot)org
cc:
Subject: [NOVICE] DESCRIBE eqivalent
I have been churning through the manual at
http://www.postgresql.org/idocs/index.php?sql-commands.html
but I see no equivalent to the MySQL DESCRIBE command to describe
a table.
What is the postgresql version of this?
Kind regards
Kevin
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
Kevin Waterson
Port Macquarie, Australia
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Devinder K Rajput | 2003-01-13 20:32:03 | Re: DESCRIBE eqivalent |
Previous Message | Kevin Waterson | 2003-01-13 20:27:46 | DESCRIBE eqivalent |