From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "Mija Lee" <mija(at)scharp(dot)org> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: references to variable in another schema |
Date: | 2007-11-09 17:52:47 |
Message-ID: | 264855a00711090952s5f5a395ep67a823badb32632@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Nov 9, 2007 12:48 PM, Mija Lee <mija(at)scharp(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-09 17:56:43 | Re: references to variable in another schema |
Previous Message | Mija Lee | 2007-11-09 17:48:52 | references to variable in another schema |