Re: How can I make postgre execute file with SQL code, on windows platform
| From: | chris smith | Date: | Sun, 26 Feb 2006 10:39:49 +0000 |
| Subject: | Re: How can I make postgre execute file with SQL code, on windows platform | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-231099@lists.php.net to get a copy of this message | ||
> 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.
Which is why I said:
---------
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
---------