Hello,
Why not just open the dump in VI or Joe (Joe doesn't handle huge files
well), and do a search an replace?
Carl Anderson wrote:
>
> I am having problems upgrading from 7.1.2 to 7.2.1
>
> are there any tools that account for the char handling change from 7.1
> to 7.2
>
> in 7.1.3 select 'hello'::char; works
>
> in 7.2.1 select 'hello'::char; fails
>
> I am ambivalent to the dataype change
> all I need is a tool that converts datatype char unmodified to varchar
> unmodified
> but leaves char modified (char(1), char(2)) alone.
>
> possibly someone who has dealt with this has a hacked pg_dump.
>
> C.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html