Thread: 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
\d [tablename] should do the trick. A lot of things are covered in slash commands instead of sql; \? shows a list. Kevin Waterson wrote: >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 > > >
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
This one time, at band camp, Jeffrey Melloy <jmelloy@visualdistortion.org> wrote: > \d [tablename] should do the trick. A lot of things are covered in > slash commands instead of sql; > \? shows a list. wonderful :) Thanks again Kevin -- Please avoid sending me Word or PowerPoint attachments. See http://www.fsf.org/philosophy/no-word-attachments.html Kevin Waterson Port Macquarie, Australia
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.Rajput@ipaper.com> Sent by: pgsql-novice-owner@postgresql.org 01/13/2003 02:28 PM | To: "Kevin Waterson" <kevin@oceania.net> cc: pgsql-novice@postgresql.org, pgsql-novice-owner@postgresql.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@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