Re: pg_dump, libdump, dump API, & backend again

On Sat, 22 Jul 2000, Philip Warner wrote:
> 
> 3. My current plan/idea/suggestion is to implement an API that, given an
> object type (eg. 'table'), will return the most basic definition for the
> object and a list of related objects. This API could be used by both psql
> and pg_dump to create SQL for display & backup purposes.
It's sounds good for me. If your API will good it is usable for more
programs than for psql and pg_dump. And a "C" API is included-able to
more langs (Python, PHP..)
A question is, what will returns from this API, full SQL statements in  
strings only or some structs too? If will here some common mechanism how 
obtain definition for tables (etc.) not is a problem start development 
on advanced client programs like Oracle Designer or make programs for 
SQL DB to XML conversion and DB schema visualization (for example in the 
nice program dia)... (don't care I know pgaccess).
IMHO all OpenSource SQL are behind in clients part. 
                    Karel