"Glen W. Mabey" <Glen(dot)Mabey(at)swri(dot)org> writes:
> When I SELECT any records from a certain table ("Acquisitions"), I get:
> acqlibdb=> select * from "Acquisitions";
> ERROR: relation "Acquisitions" does not exist
> acqlibdb=> select * from public."Acquisitions";
> ERROR: relation "public.Acquisitions" does not exist
Maybe it's not in the public schema but some other one (implying you
forgot about a nondefault search_path setting).
regards, tom lane