How can I make postgre execute file with SQL code, on windows platform
| From: | Bogdan Ribic | Date: | Sat, 25 Feb 2006 13:23:13 +0000 |
| Subject: | How can I make postgre execute file with SQL code, on windows platform | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-231056@lists.php.net to get a copy of this message | ||
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 an easy way to do it from PHP, perhaps using some postgre utility via system() call ?
Boban.
--
Open source PHP code generator for DB operations
http://sourceforge.net/projects/bfrcg/