PostgreSQL Administration - Reg:sql command

Author

Reg:sql command

sandhya

2005-08-24, 7:25 am

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

Gnanavel S

2005-08-24, 7:25 am

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.

Oliver Elphick

2005-08-24, 7:25 am

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 6: explain analyze is your friend

Sivakumar K

2005-08-24, 7:25 am

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 & #91;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

Sivakumar K

2005-08-24, 7:25 am

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 & #91;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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Gnanavel S

2005-08-24, 7:25 am

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 & #91;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:
> 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.

Jim C. Nasby

2005-08-24, 8:25 pm

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:
>
>
>
> --
> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links