dbTalk Databases Forums  

is there a sql command to display table definition?

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss is there a sql command to display table definition? in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sun H Chi
 
Posts: n/a

Default is there a sql command to display table definition? - 09-16-2004 , 05:56 PM






Is there a command similar to the oracle DESCRIBE command to view the table definitions?

Thanks


Reply With Quote
  #2  
Old   
Jake Stride
 
Posts: n/a

Default Re: is there a sql command to display table definition? - 09-16-2004 , 06:09 PM






Not to sure about oracle, but are you looking for

\dt tablename

Thanks

Jake

Sun H Chi wrote:

Quote:
Is there a command similar to the oracle DESCRIBE command to view the
table definitions?

Thanks


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.