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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]