pg_dump/load quoting.

Dear All,

pg_dump is dumping INSERT commands that fail to reload.

I'm putting stuff into a table using perl DBI; dbh->quote. A select
shows a row like:

 1047676 | 1047673 | CAB    | breeders' associations

pg_dump creates a line

INSERT INTO "keywords" ("key","extkey","system","str") VALUES (1047676,1047673,'CAB','breeders'' associations');

which throws a parser editor when I try to reload it.

dev_templates=# INSERT INTO
"keywords" ("key","extkey","system","str") VALUES
(1047676,1047673,'CAB','breeders'' associations');
ERROR:  parser: parse error at or near "associations"

Whats happening please? Its quoted correctly, isn't it? I've just read the
example/para about 'dianne''s horse'

Cheers,

Bob

Bob Parkinson
rwp@biome.ac.uk
------------------------------------------------------------------
Technical Manager:         Biome             http://biome.ac.uk/

Greenfield Medical Library,
Queens Medical Centre,
Nottingham.                          0115 9249924 x 42059
------------------------------------------------------------------
                        We are stardust