Thanks alot, you are right with the table and the -E option. It's very useful.
The only issue I find with your SQL is it relies on "(a.attnum = x.conkey[1] or
a.attnum = x.conkey[2])" which assumes there is two columns forming the primary key of
a table. Perhaps, I should explain what I'm tryi
Hi,
I need to query each column's constraint and name of a table in
postgreSQL v7.3.4 with a single SQL query but don't know how. Would
appreciate any pointers!
Thank you.
Regards,
Damon
---(end of broadcast)---
TIP 8: explain analy
