On Thu, Jun 21, 2012 at 5:42 PM, Daniele Varrazzo <daniele.varrazzo@xxxxxxxxx> wrote:
Hello,
is there a way to read the storage parameters values set on a table
(i.e. what set with ALTER TABLE foo SET (autovacuum_enabled=false) and
so on...)? I can't find it in the docs.
One way is with
\d+ <tablename>
Second with pg_class.
postgres=# select relname,reloptions from pg_class where relname='foo';
relname | reloptions
---------+----------------------------
foo | {autovacuum_enabled=false}
(1 row)
