"Scot L. Harris" <[EMAIL PROTECTED]> writes: > So given the table name is there a way to identify the column defined as > the primary key for that table?
You need to look in pg_index. Note that the primary key could be a multicolumn index, so starting with the assumption that there is "the column" is going to lead you on the wrong track. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend