On Fri, Jan 14, 2005 at 05:10:10PM -0300, Alvaro Herrera wrote: > On Fri, Jan 14, 2005 at 12:20:50PM -0700, Michael Fuhr wrote: > > On Fri, Jan 14, 2005 at 07:44:18PM +0100, Bo Lorentsen wrote: > > > Alvaro Herrera wrote: > > > > > > >You can create a function to get the sequence name attached to a table. > > > >Of course, you should take into account the fact that there could be > > > >more than one (two serial fields in a table are rare but not > > > >impossible), but if your tables have only one sequence you should be OK. > > > > > > > Are there a way to find and test if it is a primary key ? > > > > pg_index has an indisprimary column. > > Yeah, though things get hairy that way because you have to peek at > pg_attribute to match the objsubid in pg_depend; and self-join pg_class > to get to the index itself. Not sure if it all can be done in a single > query. If you do manage to write a function that will do this I hope you can share it with the community. IMHO PostgreSQL could do with more functions for querying the system catalogs. -- Jim C. Nasby, Database Consultant decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
