Dooktown=# SELECT p.relname. a.adsrc FROM pg_class p JOIN pg_attrdef a
booktown-# ON (p.relfilenode = a.adrelid)
booktown-# WHERE a.adsrc - '"shipments_ship_id_seq"';
relname | adsrc
shipments | nextvaK'"sh1pments_ship_id_seq"'::text)
(1 row)