Change History
Message: Create a Table with Incremental Primary Key
Changed By: mepoadm
Change Date: February 28, 2019 11:39PM
Create a Table with Incremental Primary Key
<pre1. Add primary key when creating a table
<div style="background:#ddd;padding-left:1em">CREATE TABLE example
(
id bigserial primary key,
name VARCHAR(255) not null,
value bigint
);</pre>div>
2. Add primary key by updating a table
<div style="background:#ddd;padding-left:1em">ALTER TABLE example add primary key (id);</div>
Changed By: mepoadm
Change Date: June 25, 2014 12:03AM
Create a Table with Incremental Primary Key
<code>CREATE TABLE example
(
id bigserial primary key,
<pre>CREATE TABLE example
(
id bigserial primary key,
name VARCHAR(255) not null,
value bigint
);</code>pre>
Original Message
作者: mepoadm
Date: June 25, 2014 12:02AM
Create a Table with Incremental Primary Key
CREATE TABLE example
(
id bigserial primary key,
name VARCHAR(255) not null,
value bigint
);
