Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group