column depends on sequence

On Thu, Aug 05, 2010 at 06:23:54PM +0600, AI Rumman wrote:

I need to write a query to find the primary key column_names that depend
on sequences.
Any help please.

On the assumption that the sort of dependence you're looking for is one where
a column has a default value of nextval('some_sequence'), this worked for me:

select
attrelid::regclass || '.' || attname,
adsrc
from
pg_attrdef ad
join pg_attribute pa
on (ad.adrelid = pa.attrelid and pa.attnum = ad.adnum)
where
adsrc ~* 'nextval'

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com