Re: [ppa-help] COPY Command and Quotes

[Jehan-Guillaume (i. de R. <io...@fr...>]

Hello,

I suspect your magic_quote_gpc to be turned on in your PHP setup.

On 10/09/2012 16:52, sh...@ip... wrote:
> The following data was submitted on 2012/09/10 14:52.
> 
> 
> 
> ====== E-mail ======
> 
> Name Sebastian Hahn PostgreSQL ver. PostgreSQL 8.3.18 phpPgAdmin
> ver. phpPgAdmin 5.0.4 (PHP 5.3.8) Comments Dear Developers,
> 
> I always get an error message using the command:
> 
> SQL error:
> 
> ERROR:  syntax error at or near "\" LINE 1: COPY warp_grid
> (id,cell,ind_ld,ind_l,geog) FROM \'/srv/www/h... ^
> 
> In statement: COPY warp_grid (id,cell,ind_ld,ind_l,geog) FROM
> \'/srv/www/htdocs/radar/warp_grid_insert.txt\' WITH DELIMITER AS
> \',\';
> 
> The original query looks like: COPY warp_grid
> (id,cell,ind_ld,ind_l,geog) FROM
> '/srv/www/htdocs/radar/warp_grid_insert.txt' WITH DELIMITER AS
> ',';
> 
> Why does phpPgAdmin add \ ? Why do I get the error msg? What needs
> to be changed? Thanks in advance!
> 
> Best regards, Sebastian