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;
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.
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's
Right now pg_options_to_table() is not documented. Should it be?
Yes, I think so.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
--
Sent via pgsql-hackers
Itagaki Takahiro wrote:
On Mon, Sep 27, 2010 at 2:19 PM, Josh Berkus j...@agliodbs.com wrote:
While working on some database maintenance, I was just tripped up by the
fact that there is no good way to query reloptions for tables. ?By no good
way I mean no way which does not involve UNNEST
Can you use pg_options_to_table() for your purpose?
Yes, thanks. What version did that get added in? Even for 9.0, that
function doesn't seem to appear in the docs.
--
-- Josh Berkus
PostgreSQL Experts Inc.
On Mon, Sep 27, 2010 at 4:39 PM, Josh Berkus j...@agliodbs.com wrote:
Can you use pg_options_to_table() for your purpose?
Yes, thanks. What version did that get added in? Even for 9.0, that
function doesn't seem to appear in the docs.
I found it in 8.4 and newer versions. It might be an
--On 27. September 2010 16:54:32 +0900 Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
I found it in 8.4 and newer versions. It might be an internal API
(for pg_dump?), but it'd be better to add documentation for it.
Additionally we could extend pg_tables with an additional column?
All,
While working on some database maintenance, I was just tripped up by the
fact that there is no good way to query reloptions for tables. By no
good way I mean no way which does not involve UNNEST and regexps or
procedural code.
This puts us in the wierd place that while one can ALTER
On Mon, Sep 27, 2010 at 2:19 PM, Josh Berkus j...@agliodbs.com wrote:
While working on some database maintenance, I was just tripped up by the
fact that there is no good way to query reloptions for tables. By no good
way I mean no way which does not involve UNNEST and regexps or procedural
