Re: Reg:sql command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 8/24/05, Sivakumar K <sivakumark@xxxxxxxxxxxxxx> 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@xxxxxxxxxx]
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@xxxxxxxxxx
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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux