Re: Using pg_dump through odbc

Yes, I think this is the only solution - to use the pg_dump.exe in my
application ... I have allready started to do so ...

Thank You,
--
Adrian Din,
Om Computer & Software

On Tue, 1 Mar 2005 11:46:18 -0600, <anthony(dot)caduto(at)micorp(dot)com> wrote:

> Just include the win32 versions of pg_dump/restore from the win32
> Postgresql 8.x release, then use the createprocess api commad to execute
> the pg_dump.exe.
> By using createprocess you can pipe the output of the exe into your Dephi
> apps window. That's all PG admin 3 does.
> Do a search on google on createprocess and piping Standard Output.
>
>
>
> Tony Caduto
> Senior Programmer/Analyst
>
>
>
>
> Din Adrian <adrian(dot)din(at)easynet(dot)ro>
> Sent by: pgsql-odbc-owner(at)postgresql(dot)org
> 03/01/2005 07:19 AM
>
> To
> pgsql-odbc(at)postgresql(dot)org
> cc
>
> Subject
> [ODBC] Using pg_dump through odbc
>
>
>
>
>
>
> Hello,
> I am using Delphi with psqlodbc and postgresql.
> The problem is that I want the users to be able to backup the database
> from client stations by pressing a button. So my question is how can I
> run
> a pg_dump or psql command from delphi through odbc and get back the
> dumped data ?
> Any ideea or maybe a workaround?
>
> Thank you,
> Adrian Din,
> Om Computer & Software
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>