pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Reg:sql command
7+ messages / 5 participants
[nested] [flat]

* Reg:sql command
@ 2005-08-24 06:20  sandhya <sandhyar@amiindia.co.in>
  0 siblings, 2 replies; 7+ messages in thread

From: sandhya @ 2005-08-24 06:20 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>; Sivakumar K <sivakumark@aztec.soft.net>

Hi,
Is there any equivalent command for '\d tablename'.
Inorder to get the table structure is there any SQL query in postgres?

Thank you,
Regards,
sandhya

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 09:13  Gnanavel S <s.gnanavel@gmail.com>
  parent: sandhya <sandhyar@amiindia.co.in>
  1 sibling, 1 reply; 7+ messages in thread

From: Gnanavel S @ 2005-08-24 09:13 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin; Sivakumar K <sivakumark@aztec.soft.net>

run the psql command with -E option and do 
\d tablename.

On 8/24/05, sandhya <sandhyar@amiindia.co.in> wrote:
> 
> Hi,
> Is there any equivalent command for '\d tablename'.
> Inorder to get the table structure is there any SQL query in postgres?
>  Thank you,
> Regards,
> sandhya
> 



-- 
with regards,
S.Gnanavel
Satyam Computer Services Ltd.

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 09:16  Oliver Elphick <olly@lfix.co.uk>
  parent: sandhya <sandhyar@amiindia.co.in>
  1 sibling, 0 replies; 7+ messages in thread

From: Oliver Elphick @ 2005-08-24 09:16 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin; Sivakumar K <sivakumark@aztec.soft.net>

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@lfix.co.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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 09:51  Sivakumar K <sivakumark@aztec.soft.net>
  0 siblings, 1 reply; 7+ messages in thread

From: Sivakumar K @ 2005-08-24 09:51 UTC (permalink / raw)
  To: olly@lfix.co.uk, sandhya <sandhyar@amiindia.co.in>; +Cc: 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@lfix.co.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@lfix.co.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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 09:55  Sivakumar K <sivakumark@aztec.soft.net>
  0 siblings, 0 replies; 7+ messages in thread

From: Sivakumar K @ 2005-08-24 09:55 UTC (permalink / raw)
  To: olly@lfix.co.uk, sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

Oops sorry for that post.
Actually we need to do like this.
Psql -E -U siva -d template1
Template1=>\d test;
It gives the queries.


Thanks
Siva Kumar.K

-----Original Message-----
From: Oliver Elphick [mailto:olly@lfix.co.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@lfix.co.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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 11:52  Gnanavel S <s.gnanavel@gmail.com>
  parent: Sivakumar K <sivakumark@aztec.soft.net>
  0 siblings, 0 replies; 7+ messages in thread

From: Gnanavel S @ 2005-08-24 11:52 UTC (permalink / raw)
  To: Sivakumar K <sivakumark@aztec.soft.net>; +Cc: pgsql-admin

On 8/24/05, Sivakumar K <sivakumark@aztec.soft.net> wrote:
> 
> 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)


add the missing quotes 
 psql -E -U siva -d template1 -c "\d test"

Am I missing anything here?
> Regards,
> Siva Kumar.K
> 
> -----Original Message-----
> From: Oliver Elphick [mailto:olly@lfix.co.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@lfix.co.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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faq
> 



-- 
with regards,
S.Gnanavel
Satyam Computer Services Ltd.

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Reg:sql command
@ 2005-08-24 18:19  Jim C. Nasby <jnasby@pervasive.com>
  parent: Gnanavel S <s.gnanavel@gmail.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Jim C. Nasby @ 2005-08-24 18:19 UTC (permalink / raw)
  To: Gnanavel S <s.gnanavel@gmail.com>; +Cc: sandhya <sandhyar@amiindia.co.in>; pgsql-admin; Sivakumar K <sivakumark@aztec.soft.net>

You should also take a look at
http://pgfoundry.org/projects/newsysviews/; it makes getting this kind
of info out of the database much easier.

On Wed, Aug 24, 2005 at 02:43:31PM +0530, Gnanavel S wrote:
> run the psql command with -E option and do 
> \d tablename.
> 
> On 8/24/05, sandhya <sandhyar@amiindia.co.in> wrote:
> > 
> > Hi,
> > Is there any equivalent command for '\d tablename'.
> > Inorder to get the table structure is there any SQL query in postgres?
> >  Thank you,
> > Regards,
> > sandhya
> > 
> 
> 
> 
> -- 
> with regards,
> S.Gnanavel
> Satyam Computer Services Ltd.

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2005-08-24 18:19 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-24 06:20 Reg:sql command sandhya <sandhyar@amiindia.co.in>
2005-08-24 09:13 ` Gnanavel S <s.gnanavel@gmail.com>
2005-08-24 18:19   ` Jim C. Nasby <jnasby@pervasive.com>
2005-08-24 09:16 ` Oliver Elphick <olly@lfix.co.uk>
2005-08-24 09:51 Re: Reg:sql command Sivakumar K <sivakumark@aztec.soft.net>
2005-08-24 11:52 ` Gnanavel S <s.gnanavel@gmail.com>
2005-08-24 09:55 Re: Reg:sql command Sivakumar K <sivakumark@aztec.soft.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox