Re: DESCRIBE eqivalent

oooops...answered the wrong questions...sorry about that...I don't know
what I was thinking -;)

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474

"Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
Sent by: pgsql-novice-owner(at)postgresql(dot)org
01/13/2003 02:28 PM

To: "Kevin Waterson" <kevin(at)oceania(dot)net>
cc: pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org
Subject: Re: [NOVICE] DESCRIBE eqivalent

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