dbTalk Databases Forums  

More info on table fields

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss More info on table fields in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alexander Cohen
 
Posts: n/a

Default More info on table fields - 03-02-2004 , 07:18 AM






Im looking to get a bit of info from a tables column. Im looking for if
the column is a primary key, im also looking for the columns
constraints and its foreign key reference if it is one. How can i get
theses with an SQL query?



--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


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.