| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Reading storage parameters |
| Date: | 2012-06-21 12:27:48 |
| Message-ID: | CA+h6Ahhu37EXwnVgvDfS7D1Nzq2ervcRzvn-Pv4JepW38yMY4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 21, 2012 at 5:42 PM, Daniele Varrazzo <
daniele(dot)varrazzo(at)gmail(dot)com> 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)
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniele Varrazzo | 2012-06-21 12:35:30 | Re: Reading storage parameters |
| Previous Message | Thom Brown | 2012-06-21 12:26:05 | Re: Reading storage parameters |