Re: ERROR: parser: unterminated quoted string

--- Daniel Secomb <dan(at)ds-d(dot)com> wrote:

> Hi,
>
> I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and
> I'm getting the following
> error when I try and run a SQL query on a script:
>
> Error -
>
/usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php
> --
> Line: 33
> PostgreSQL said: ERROR: parser: unterminated quoted
> string at or near
> "'Black Tea\015\012Fresh range of leaf tea for
> drinking black or with
> milk,\015\012including Ceylons, Assams and
> favourites like Irish
> Breakfast.\015\012\015\012Green Tea\015\012First
> quality Japanese & Chinese
> popular green teas, including Bancha, Genmaicha &
> flavoured green
> teas.\015\012\015\012Flavoured Tea\015\012Exotic and
> delicious, favourites
> are Vanilla, Arctic Fire & Lady
> Grey.\015\012\015\012Herbal
> Infusions\015\012Pure flowers and whole leaves of
> calming herbs, &
> a\015\012delightful range of specially blended
> herbal infusions Fruit
> Melanges;" at character 566
>
>
>
> Any idea as to why this is doing this?

Because there is an unterminated quoted string? I see
a single quote just before "Black Tea", but I don't
see another anywhere in that string.

>
> Thank you for your help.
>
> Dan
>

__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail