postgresql - 在与字段相同的行上声明外键？

Question

这有效，但很冗长：

CREATE TABLE located (
    id SERIAL NOT NULL PRIMARY KEY,
    container_id BIGINT NOT NULL,
    CONSTRAINT fk_l2c FOREIGN KEY (container_id) REFERENCES containers
);

这次尝试：

CREATE TABLE located (
    id SERIAL NOT NULL PRIMARY KEY,
    container_id BIGINT NOT NULL FOREIGN KEY REFERENCES containers
);

失败：

ERROR:  syntax error at or near "FOREIGN"
LINE 3:     container_id BIGINT NOT NULL FOREIGN KEY REFERENCES cont...

有没有办法在与 container_id 相同的行上声明外键？

标签： postgresqlforeign-keys