Re: references to variable in another schema

On Nov 9, 2007 12:48 PM, Mija Lee <mija@scharp.org> wrote:
> Hi folks:
>
> I wanted to put a reference on a table in the public schema that
> references a column in a table in another schema. I tried:
>
> create table cellphone(emplid integer not null references
> admin.tbl_employee.employee_id);
>
> ERROR:  cross-database references are not implemented:
> "admin.tbl_employee.employee_id"
>
> But these are within one database. Is there a way to do this or have I
> gotten my syntax messed up?

The hierarchy in postgresql is Server->database->schema->table->column

How as "admin" created?  By using "create schema admin" or something else?

Sean