Re: How to display structure of a table

From: Chris Green <chris(at)areti(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to display structure of a table
Date: 2004-11-25 10:47:33
Message-ID: 20041125104733.GK539@areti.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 25, 2004 at 04:08:30PM +0530, Nageshwar Rao wrote:
> I have created a table and would like to display the structure to find
> out datatype and length.
>
> Just like in Oracle describe table_name;

in psql:-

\dt

Basically the \d commands in psql give you much of what DESCRIBE does
for Oracle and mysql. \? to see all the \ commands.

--
Chris Green (chris(at)areti(dot)co(dot)uk)

"Never ascribe to malice, that which can be explained by incompetence."

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-11-25 11:24:36 Re: [HACKERS] Help!
Previous Message Nageshwar Rao 2004-11-25 10:38:30 How to display structure of a table