From: | "Usama Munir" <usama(dot)munir(at)enterprisedb(dot)com> |
---|---|
To: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
Cc: | "Naz Gassiep" <naz(at)mira(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_get_tabledef |
Date: | 2007-05-21 18:37:23 |
Message-ID: | 4651E6E3.3030801@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Got it. Thanks for the clarification , i suppose the way you described
it , it needs to go over libpq for the database interface, not the
HeapTuple / Form_pg_* , way.
I guess the way forward for me would be to crawl back in my corner,
write up a mini - spec of how i intend to implement it and get back to
you guys.
Thanks for your feedback.
Regards,
Usama Munir.
Andrew Dunstan wrote:
>
> I mean as a shared library - a .so for Unix (or whatever the flavor of
> unix uses instead) or a DLL on WIndows. And no, it would not be in
> contrib - as I mentioned in another thread yesterday I want to propose
> that contrib disappear.
>
> Certainly pg_dump would use the library, and retain all the file
> handling processing it does now. But we could also link it into psql,
> for example, and expose the results via \ commands.
>
> If you want to have a go at that you'll probably make lots of people
> very happy.
>
> cheers
>
> andrew
>
>
> Usama Munir wrote:
>> When you say pgdump library, do you mean taking all catalog querying
>> functionality into a contrib like module , exposed as functions and
>> then have a simple pgdump executable which calls those functions to
>> dump to a file, because you would still need a pgdump executable i
>> suppose for people to be able to backup their stuff. Is my
>> understanding somewhere near actual idea or i am way off here?
>>
>>
>> Are there any discussions on this topic which could give me a little
>> more idea? because i would definitely like to take a shot at this.
>>
>> Regards,
>> Usama Munir
>> EnterpriseDB (www.enterprisedb.com)
>>
>>
>> Andrew Dunstan wrote:
>>>
>>>
>>> Usama Munir wrote:
>>>> I think using pg_dump in some cases is a good option , but not all
>>>> the time, having a function makes it much cleaner to use
>>>
>>> That's why having a shared pgdump library as has been previously
>>> mentioned is by far the best solution.
>>>
>>> We have discussed this before, and factoring out this functionality
>>> into a shared lib is what needs to be done. I'm not convinced it is
>>> as much work as Tom suggests, but it is certainly a non-trivial task.
>>>
>>> cheers
>>>
>>> andrew
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-05-21 18:45:55 | Re: pg_get_tabledef |
Previous Message | Andrew Dunstan | 2007-05-21 18:27:58 | Re: pg_get_tabledef |