From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | alejandrob(at)pasteleros(dot)org(dot)ar |
Cc: | posgres support <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: postgres 9.2 error whit apostrophes |
Date: | 2013-06-11 21:42:27 |
Message-ID: | CAOR=d=3PDv-eBU7GCS9y6CWgRGT7_2nzHdAaQLrngFpV==wftQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Jun 11, 2013 at 2:57 PM, Alejandro Brust
<alejandrob(at)pasteleros(dot)org(dot)ar> wrote:
> Hello, excuse my English first
>
> we recently move from pg9.0 to pg 9.2 whit this method:
>
> from a new server PG9.2 we did:
> pg_dump -h server -p 5432 -U user -Fc -i -b base-name > bk.backup
>
> after that in the new server
> createdb -T template0 -E LATIN1 basename
> pg_restore -h server -p 5432 -U user -d basename bk.backup
>
> now we are having problems with updates on tables whit apostrophes like >>
> o'higgins << on any character fields
> First question:
> is there any configurable parameter for PG9.2 that make
> update tu02t00 set tu02pfusua = 'D'AGOSTINO' work...
> the server error said
>
> ERROR: syntax error at or near "AGOSTINO" at character 187
>
> Second question:
> If there is no way to configure PG9.2 to accept this Cain of update
> which is the best method to do a downgrade from 9.2 to 9.0 (we are not using
> any new function)
That shouldn't work in any version of postgresql.
Two ways to insert that.
1: escape it:
update tu02t00 set tu02pfusua = 'D''AGOSTINO' ...
2: Use $$ quotes:
update tu02t00 set tu02pfusua = $$D'AGOSTINO$$ ...
From | Date | Subject | |
---|---|---|---|
Next Message | Alejandro Brust | 2013-06-11 22:28:06 | Re: postgres 9.2 error whit apostrophes |
Previous Message | Alejandro Brust | 2013-06-11 20:57:15 | postgres 9.2 error whit apostrophes |