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