Re: Ideas input sought for this year's SOC page

Josh Berkus wrote:
> Hackers,
>
> We need to update the SoC page:
> http://www.postgresql.org/developer/summerofcode
>
> ... with new ideas and projects appropriate for PostgreSQL 8.4/8.5.
> Please make suggestions. Thanks!
>
> --Josh
>
On last year's summer of code page,
http://www.postgresql.org/developer/summerofcode

There is the following item:
*
DDL Functions*: Create a SQL-callable function capable of generating DDL
scripts for objects within the database.

Is there more information available on this?
Has anything like this been implemented?

I believe SQL standard does not specify such functions.
What functions and parameters?
What other functionality is required?

I have a usable implementation of this functionality,
but it needs some more work before it is released.

Here is some info:
http://developer.postgresql.org/index.php/DDL_Functions

Currently it is a part of larger utility package, but
I would very much like release it as a stand alone
project on pgfoundry.

The plan is is to review current functions and move them
to a separate namespace before release.
This is a good time to make API changes.

Suggestions are much appreciated.

Thank you

Z.