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? Thanks, Steve