quoting problem?
Terry Mackintosh <terry@terrym.com>
From: Terry Mackintosh <terry@terrym.com>
To: PostgreSQL-development <hackers@postgreSQL.org>
Date: 1998-11-05T14:26:50Z
Lists: pgsql-hackers
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@terrym.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!