From: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Reading storage parameters |
Date: | 2012-06-21 12:35:30 |
Message-ID: | CA+mi_8bT8C8f4VxEd3j3RV=gGhCcM8UebSFdi-1VZ+D_6z5p7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jun 21, 2012 at 1:26 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 21 June 2012 13:12, 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.
>
> SELECT c.reloptions
> FROM pg_class c
> INNER JOIN pg_namespace n
> ON c.relnamespace = n.oid
> WHERE c.relname = 'tablename'
> AND n.nspname = 'schemaname';
Ok, so they are in pg_class.reloptions, thank you!
-- Daniele
From | Date | Subject | |
---|---|---|---|
Next Message | Evan Martin | 2012-06-21 13:51:18 | Re: Please make it easy to drop a database that is in use |
Previous Message | Raghavendra | 2012-06-21 12:27:48 | Re: Reading storage parameters |