Alejandro Brust wrote
>>
>> Two ways to insert that.
>>
>> 1: escape it:
>> update tu02t00 set tu02pfusua = 'D''AGOSTINO' ...
>>
>> 2: Use $$ quotes:
>>
>> update tu02t00 set tu02pfusua = $$D'AGOSTINO$$ ...
>>
> YES, from psql that work great
> I will explain more,
> we were using a jdbc7 from gene
El 11/06/2013 18:42, Scott Marlowe escribió:
> On Tue, Jun 11, 2013 at 2:57 PM, Alejandro Brust
> 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 >
On Tue, Jun 11, 2013 at 2:57 PM, Alejandro Brust
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 -
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 b
yum install postgresql91-server didn't do the
trick to update 9.1.4 to 9.1.9.
The pgdg-91-centos.repo points to rhel, so maybe since we run centos 6.3 yum
install command bombs when it can't find rhel. Maybe, yum doesn't know to look
in /usr/pgsql-9.1. Maybe it was because my base version wa
