Hi,

Read http://www.postgresql.org/docs/8.4/static/sql-createtable.html

> REFERENCES *reftable* [ ( *refcolumn* ) ] [ MATCH *matchtype* ] [ ON
> DELETE *action* ] [ ON UPDATE *action* ] (column constraint)
> FOREIGN KEY ( *column* [, ... ] ) REFERENCES *reftable* [ ( *refcolumn* [,
> ... ] ) ] [ MATCH *matchtype* ] [ ON DELETE *action* ] [ ON UPDATE *action
> * ] (table constraint)


HTH

Regards,

Serge Fonville

On Thu, Sep 24, 2009 at 4:18 PM, 纪晓曦 <sheep...@gmail.com> wrote:

> To be precise,
>
> The difference between
>
> create table a (
>      foreign key (id) referenced by b(name),
> );
>
> create table b(
>       id  integer referenced by b(name),
> );
>



-- 
Convince Google!!
They need to support Adsense over SSL
https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528
http://www.google.bg/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en

Reply via email to