Re: How can I make postgre execute file with SQL code, on windows platform
| From: | Bogdan Ribic | Date: | Sun, 26 Feb 2006 10:33:28 +0000 |
| Subject: | Re: How can I make postgre execute file with SQL code, on windows platform | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-231098@lists.php.net to get a copy of this message | ||
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/