Skip to main content
added 4 characters in body
Source Link
user330315
user330315

I think you want the 'references' keyword. For example:

https://www.postgresql.org/docs/9.2/ddl-constraints.htmlhttps://www.postgresql.org/docs/current/ddl-constraints.html

create table inventory ( id INTEGER NOT NULL UNIQUE, ... other fields ); create table events ( eid INTEGER REFERENCES inventory(id), ... other fields ); 

I think you want the 'references' keyword. For example:

https://www.postgresql.org/docs/9.2/ddl-constraints.html

create table inventory ( id INTEGER NOT NULL UNIQUE, ... other fields ); create table events ( eid INTEGER REFERENCES inventory(id), ... other fields ); 

I think you want the 'references' keyword. For example:

https://www.postgresql.org/docs/current/ddl-constraints.html

create table inventory ( id INTEGER NOT NULL UNIQUE, ... other fields ); create table events ( eid INTEGER REFERENCES inventory(id), ... other fields ); 
Source Link
Craeft
  • 227
  • 1
  • 11

I think you want the 'references' keyword. For example:

https://www.postgresql.org/docs/9.2/ddl-constraints.html

create table inventory ( id INTEGER NOT NULL UNIQUE, ... other fields ); create table events ( eid INTEGER REFERENCES inventory(id), ... other fields );