Re: Copy table to file inside PHP
| From: | Brian C. Doyle | Date: | Mon, 05 Feb 2001 16:15:51 +0000 |
| Subject: | Re: Copy table to file inside PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6398@lists.php.net to get a copy of this message | ||
What is the error you get?
To do the Copy you need to specify a userid in your pg_connect like
$conn = pg_connect ("host=localhost port=5432 user=userid dbname=dbname");
That should take care of it. It did for me!
At 12:02 AM 2/6/01 +0900, Achmad Gutomo wrote:
Hi PHP Gurus ! Anyone have idea to copy table to file from the web? From the unix shell we can do : COPY table_name TO '/home/someone/table_name.dat' ; I tried inside PHP $con=pg_connect("","","","",dbname); $result=pg_exec($con,"COPY table_name TO '/home/someone/table_name.dat'"); pg_close($con); but got error. I use Apache+PHP+PostgreSQL on Redhat7 Any suggestion for me ? Thank for your help ! GTM