Copy table to file inside PHP
| From: | Achmad Gutomo | Date: | Mon, 05 Feb 2001 15:02:52 +0000 |
| Subject: | Copy table to file inside PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6396@lists.php.net to get a copy of this message | ||
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