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@oceania.net> Sent by: pgsql-novice-owner@postgresql.org
01/13/2003 02:27 PM
To: pgsql-novice@postgresql.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@postgresql.org