Thread

Re: TODO: You can alter it, but you can't view it

Bruce Momjian <bruce@momjian.us> — 2011-02-26T17:49:28Z

bruce wrote:
> Josh Berkus wrote:
> > 
> > > Right now pg_options_to_table() is not documented.  Should it be?
> > 
> > Yes, I think so.
> 
> Done, with the attached, applied patch.

Oh, here is an example usage:

	test=> select pg_options_to_table(reloptions) from pg_class;
	       pg_options_to_table
	----------------------------------
	 (fillfactor,50)
	 (autovacuum_freeze_table_age,10)
	(2 rows)

It also works for pg_attribute.attoptions, so I documented that too.
I also fixed the documented return type in my previous patch.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +