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

Re: Reg:sql command

From: Sivakumar K <sivakumark(at)aztec(dot)soft(dot)net>
To: olly(at)lfix(dot)co(dot)uk, sandhya <sandhyar(at)amiindia(dot)co(dot)in>
Cc: postgre <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reg:sql command
Date: 2005-08-24 09:51:44
Message-ID: 584DE893B0E08F4B9748E295029F1E9702EA51A5@maya.aztec.soft.net (view raw or flat)
Thread:
Lists: pgsql-admin
Oliver,
How should I use this?
I tried this way but of no use.
psql -E -U siva -d template1 -c \d test (test is a table in template1)


Am I missing anything here?	
Regards,
Siva Kumar.K

-----Original Message-----
From: Oliver Elphick [mailto:olly(at)lfix(dot)co(dot)uk] 
Sent: Wednesday, August 24, 2005 2:47 PM
To: sandhya
Cc: postgre; Sivakumar K
Subject: Re: [ADMIN] Reg:sql command

On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote:
> Hi,
> Is there any equivalent command for '\d tablename'.
> Inorder to get the table structure is there any SQL query in postgres?
>  
use psql -E to see the SQL commands that are used to implement \d and
other such commands.

-- 
Oliver Elphick                                          olly(at)lfix(dot)co(dot)uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
                 ========================================
   Do you want to know God?   http://www.lfix.co.uk/knowing_god.html

Responses

pgsql-admin by date

Next:From: Sivakumar KDate: 2005-08-24 09:55:03
Subject: Re: Reg:sql command
Previous:From: Oliver ElphickDate: 2005-08-24 09:16:59
Subject: Re: Reg:sql command

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