DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=s4vhQU/bc1grxCIdjuQj3qxmYlEsU2wohduLJMnRg9hqT1RhDBYSTOQ/Bkr1l1eyUZUcITNhlMvZJepmR/GuYavNOaCRbBxiv+KTfIGmmumTiKHf30snYSdvYLTGxZP/jW9K0JZqwkk2yCiuMfjHD3U84gHuQFwMmm5TtV6fT2M=
Message-ID: <dcc563d10708101523y6621f875w430bb1be0ff273f5@mail.gmail.com>
Date: Fri, 10 Aug 2007 17:23:51 -0500
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "gherzig@fmed.uba.ar" <gherzig@fmed.uba.ar>
Subject: Re: foreign key pointing to diff schema?
Cc: pgsql-sql@postgresql.org
In-Reply-To: <23920.190.55.64.163.1186784101.squirrel@www.webmail.fmed.uba.ar>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <23920.190.55.64.163.1186784101.squirrel@www.webmail.fmed.uba.ar>

On 8/10/07, gherzig@fmed.uba.ar <gherzig@fmed.uba.ar> wrote:
> Hi all. Can i make a FK who points a table in a different schema? Or this
> is implemented via a trigger by my own?

Sure.  just prefix the table name with the schemaname and a .

create schema abc;
alter user me set search_path='abc', 'public';
create table z1 (id int primary key);
 \d z1
        Table "abc.z1"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer | not null
Indexes:
    "z1_pkey" PRIMARY KEY, btree (id)

(Note the abc.z1 there)
create schema test3;
 create table test3.z2 (id int primary key, z1id int references abc.z1(id));
\d test3.z2
       Table "test3.z2"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer | not null
 z1id   | integer |
Indexes:
    "z2_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "z2_z1id_fkey" FOREIGN KEY (z1id) REFERENCES z1(id)


basically, schemas are just distinct name spaces.