On Mon, Feb 04, 2008 at 08:12:51PM +0100, fkater@googlemail.com 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@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy