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\"");
But thanx anyway :)
Boban.
chris smith wrote:
pg_connect($connection_string);
pg_query("drop schema public");
....
import data
....
or am I missing something here?
You might be better of not doing this with php.
Create the dump on the first machine.
Copy the dump (scp, rsync, copy via samba-mounted drive, whatever)
import it
It depends what your end goal is.
--
Open source PHP code generator for DB operations
http://sourceforge.net/projects/bfrcg/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php