Re: [GENERAL] Check table storage parameters

2012-11-16 Thread Lee Hachadoorian
> On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian > wrote: >> >> How can I read the current storage parameters for an existing table? >> Specifically interested in autovacuum_enabled. On Fri, Nov 16, 2012 at 12:08 PM, Mike Blackwell wrote: > Try pg_class.reloptions? That was it. Interesting

Re: [GENERAL] Check table storage parameters

2012-11-16 Thread Mike Blackwell
Try pg_class.reloptions? __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://

[GENERAL] Check table storage parameters

2012-11-16 Thread Lee Hachadoorian
How can I read the current storage parameters for an existing table? Specifically interested in autovacuum_enabled. Sorry to ask such basic question, but I can't find this in the docs, and every search I've tried ends up taking me to how to *set* the parameter with CREATE TABLE and ALTER TABLE. T