id bigserial PRIMARY KEY, mainid bigint, d4 text, e5 text, CONSTRAINT secondary_fkey FOREIGN KEY(mainid) REFERENCES main(id) ); 我想将stage中的数据同时插入main和secondary,但我不太确定如何通过重用main中生成的bigserial来实现这一点。我正在尝试一个with query,但是我在secondary中得到的行(指数)比...
Big serial in mysql Code Example, MySQL PostgreSQL SQLite TINYINT SMALLINT INTEGER SMALLINT SMALLINT MEDIUMINT INTEGER BIGINT BIGINT BIT BIT INTEGER Is there a difference in the functionality of SERIAL in Postgresql? Question: My postgres table includes an id that is automatically generated in a ...