[GENERAL] Check table storage parameters
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. Thanks, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Check table storage parameters
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://www.rrdonnelley.com http://www.rrdonnelley.com/ * mike.blackw...@rrd.com* On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian lee.hachadooria...@gmail.com wrote: 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. Thanks, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Check table storage parameters
On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian lee.hachadooria...@gmail.com 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 mike.blackw...@rrd.com wrote: Try pg_class.reloptions? That was it. Interestingly, if the table uses the server default, reloptions is NULL. Best, --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general