quoting problem?

Hi all

I am running an older snapshoot of 6.4, so this may not be relavent now.

I did a 'pg_dumpall -z > file.dump', then on another box destroyed all the
databases and did 'psql templet1 < file.dump' and got this:

REVOKE ALL on 'board' from PUBLIC;
ERROR: parser: parse error at or near "'"
GRANT ALL on "board" to "nobody";
CHANGE

It would seem that the single quotes should be double quotes?
Jan, is this your area?

I have notice that most all names now are quoted in dumps, but will work
just fine with out any quotes, so why the quotes?

Thanks, and have a great day
Terry Mackintosh <terry(at)terrym(dot)com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!