Use postgresql COPY comand in php file

Question

Is it possible to use the postgresql COPY command in a php file?

I need to download table content from a database table to a file using a php script

    $sql = " COPY tablename TO STDOUT WITH DELIMITER ',' ";

    $db->query( $sql );

This code does not work for me, what is the right way?

"not works" is not a valid Postgres error message (and I doubt it's a valid PHP error message either). — user330315
– user330315, Commented Apr 22, 2013 at 14:20

Daniel Vérité · Accepted Answer · 2013-04-22 20:43:24Z

2

php provides pg_copy_to that implements COPY to a php array, one element per row.

$rows = pg_copy_to($connection, "tablename", ",");

answered Apr 22, 2013 at 20:43

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

But what if I don’t want to export a table but a query? And don’t want to get a rows array but stream to stdout?