Skip site navigation (1)
Skip section navigation (2)
I have data that I'm running through pg_escape_sting in php and then adding to stdin for a copy command. The problem is "O'reilly" is being changed to "O''Reilly" in the string and then in the db. I saw with the copy command I can specify the escape but it isn't working for me. Should this command fix this double 'single' quote issue when I put it in the db? And what is the proper syntax?
COPY mytable FROM stdin with escape
Thanks!
Peripheral Links
Header And Logo
|
Site Navigation
copy with escape
- From: "blackwater dev" <blackwaterdev(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: copy with escape
- Date: Mon, 25 Feb 2008 21:20:24 -0500
I have data that I'm running through pg_escape_sting in php and then adding to stdin for a copy command. The problem is "O'reilly" is being changed to "O''Reilly" in the string and then in the db. I saw with the copy command I can specify the escape but it isn't working for me. Should this command fix this double 'single' quote issue when I put it in the db? And what is the proper syntax?
COPY mytable FROM stdin with escape
Thanks!
- Follow-Ups:
- Re: copy with escape
- From: brian
- Re: copy with escape
- From: Tom Lane
- Re: copy with escape
- Prev by Date: Re: Windows 8.3 installer leaves a debug flag on?
- Next by Date: Re: copy with escape
- Previous by thread: syntax error at or near "PROCEDURAL"
- Next by thread: Re: copy with escape
- Indexes: