Re: Check table storage parameters

Поиск
Список
Период
Сортировка
От Lee Hachadoorian
Тема Re: Check table storage parameters
Дата
Msg-id CANnCtnKP+-iobFBzQfHjG0S4+zu2LYfifcL6xusuZAbftjLo7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Check table storage parameters  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-general
> On Fri, Nov 16, 2012 at 10:11 AM, Lee Hachadoorian
> <Lee.Hachadoorian+L@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.blackwell@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/


В списке pgsql-general по дате отправления: