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(at)biome(dot)ac(dot)uk
------------------------------------------------------------------
Technical Manager: Biome http://biome.ac.uk/

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