Tom Allison <tallison@tacocat.net> writes:
> I'll get back to it later. I've had to learn how to dump/restore really quick
> because somewhere the indexes were built with some "illegal" names and I
> couldn't drop them. The names where "public.email_address" instead of
> "email_address" for a table in the public schema. pgaccess is not my friend
> anymore.
Think you need to learn the rules for double-quoted identifiers:
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
regards, tom lane