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

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\); But thanx

[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

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-create it