On Fri, Mar 16, 2007 at 07:06:57PM -0000, Bruce McAlister wrote: > Okay, I'm getting a little further now. I'm about to create entries in the > pg_autovacuum system tables. However, I'm a little confused as to how I go > about finding out the OID value of the tables. The pg_autovacuum table > requires the OID of the table you want to create settings for (vacrelid). > Can anyone shed some light on how I can extract the OID of the table? Also, > what happens if you create a table without OID's, are you still able to add > it's details in the pg_autovacuum table if there is no OID associated with a > table?
The easiest would seem to be to be: SELECT 'mytable'::regclass; That will get you the OID without you having to look it up yourself. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
