Joey K. wrote:
Hello, I've created a table in public schema, CREATE TABLE public.foo (fooid SERIAL);When I try to create a table in database nowhere that references public.foo table,CREATE DATABASE nowhere; \c nowhere; CREATE TABLE bar (bar integer REFERENCES public.foo(fooid)); I get, ERROR: relation "public.foo" does not exist. Can I reference public relations from private database?
You cannot. But you can create a private schema along the public one above in the same database. Regards Tino
smime.p7s
Description: S/MIME Cryptographic Signature