On Mon, Feb 04, 2008 at 08:12:51PM +0100, fkater@xxxxxxxxxxxxxx wrote: > what's an alternative to tableoids? > > As I've learned today they are not consistant across pg_dump/restore. > > I need to point to (lots of dynamically added) tables and used tableoids > before. > > Are there other solutions to point to tables besides using tableoids > or wasting disk space using the strings of 'schema' and 'tablename' > everywhere as a reference? Use regclass, takes the same space as OIDs but works across dump/restore. For tables anyway (not indexes etc al) Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
