Re: [PHP] How can I make postgre execute file with SQL code, on windows platform

>Goal was to get postgre to execute/import an sql dump file, ie not to > write import-export functionality myself. In the end, I used piping, > something like this: > > system("type $filename | \"C:\Program > Files\PostgreSQL\8.1\bin\psql.exe\" -h localhost -p 5432 X6tmp > \"postgres\""); > >

Re: [PHP] How can I make postgre execute file with SQL code, on windows platform

Hi Chris, Goal was to get postgre to execute/import an sql dump file, ie not to write import-export functionality myself. In the end, I used piping, something like this: system("type $filename | \"C:\Program Files\PostgreSQL\8.1\bin\psql.exe\" -h localhost -p 5432 X6tmp \"postgres\"");

Re: [PHP] How can I make postgre execute file with SQL code, on windows platform

On 2/26/06, Bogdan Ribic <[EMAIL PROTECTED]> wrote: > Hi all, > >I need to synchronize two postgresql servers, but synchronization is > one-directional (ie, data from one computer needs to be copied to > another). Basically, I want the target computer to drop the schema > "public" and then re-c

[PHP] How can I make postgre execute file with SQL code, on windows platform

Hi all, I need to synchronize two postgresql servers, but synchronization is one-directional (ie, data from one computer needs to be copied to another). Basically, I want the target computer to drop the schema "public" and then re-create it from my dump made on the source machine. Is there