Re: What is the difference of foreign key? - Mailing list pgsql-general

From Lew
Subject Re: What is the difference of foreign key?
Date
Msg-id h9h277$lo9$1@news.albasani.net
Whole thread Raw
In response to What is the difference of foreign key?  (sheepjxx <sheepjxx@gmail.com>)
List pgsql-general
sheepjxx 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),
> );

They're just two different forms of invalid SQL.  The difference between them
makes no difference.

--
Lew

pgsql-general by date:

Previous
From: Grant Maxwell
Date:
Subject: Re: Looking for way to replicate master db to multiple mobile databases
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] libpq port number handling