ihue ihue - 1 year ago 103
MySQL Question

Export a PSQL table in PHP

I have a languages tables in psql that look like this.

enter image description here

My goal is to export my
table and import that back in using PHP.

I've tried



shell_exec('psql -E -U postgres -d portal -c "COPY languages TO \'/Applications/MAMP/htdocs/code/benu/ssc-portal/public/csv/languages.csv\' DELIMITER \',\' "');

I got my
to export successfully.

If I open it up, it contain this.

1,h,Advanced Settings,Geavanceerde instellingen,Ajustes avanzados,Réglages avancés,2016-11-23 14:41:25,2016-11-23 14:41:25

My goal is get my
to exactly in this format

1,'h','Advanced Settings','Geavanceerde instellingen','Ajustes avanzados','Réglages avancés','2016-11-23 14:41:25','2016-11-23 14:41:25'

Because it is the only format that will accept by


How do I adjust my psql command to get that ?


Updating it using PHP is my only option ?

I'm opening to any suggestions at this moment.

Any hints / suggestions / helps on this be will be much appreciated !

Answer Source

Looks like the FORCE_QUOTE option on COPY can take a list of columns to wrap. See here: SQL COPY

FORCE_QUOTE { ( column_name [, ...] ) | * }

This means you can specify or it does all by default, you probably want the specify given your id column is not quote wrapped in your example.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download