Re: TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),

>> Maybe I am misunderstanding the TODO (which is entirely possible due to
>> the complete lack of documentation on the feature) but I *thought* all I
>> was going to do was create 6 functions that could be called to get
>> various useful information?
>>
>> For example, pg_get_tabledef() would be a very handy function to use for
>> just about any abstracted API. As it stands now most (like Pear) create
>> their own custom queries/functions to handle it but they are more often
>> then not very innefficient.
>
> I thought the TODO item was exactly what you described:
>
> * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),
> pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
>
> We have per-server-version checks in pg_dump, so I figured the idea was
> to use more of those functions if the exist, like we do now. It is true
> that you can't modify them for old versions as easily as you can if they
> are hardcoded in pg_dump, but we our existing functions seems to work
> fine.
>

O.k. so now what I am getting from this thread is, the functions exist
now in pg_dump but we want to pull them out of pg_dump and push them
into the backend?

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/