Re: [GENERAL] Reading storage parameters

2012-06-21 Thread Daniele Varrazzo
On Thu, Jun 21, 2012 at 1:26 PM, Thom Brown wrote: > On 21 June 2012 13:12, Daniele Varrazzo 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 do

Re: [GENERAL] Reading storage parameters

2012-06-21 Thread Raghavendra
On Thu, Jun 21, 2012 at 5:42 PM, Daniele Varrazzo < daniele.varra...@gmail.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

Re: [GENERAL] Reading storage parameters

2012-06-21 Thread Thom Brown
On 21 June 2012 13:12, Daniele Varrazzo 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_name

[GENERAL] Reading storage parameters

2012-06-21 Thread Daniele Varrazzo
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. -- Daniele -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs