<p>我对PostgreSQL不熟悉。我试图创建一个表,试图在同一列中添加一个主键和自动递增,但出现了一个错误</p>
<pre><code>ERROR: syntax error at or near "SERIAL"
LINE 2: upID int SERIAL primary key
</code></pre>
<p>下面是我的问题</p>
<pre><code>create table tblIK(
upID int SERIAL primary key,
upName varchar(100) NOT NULL,
upMin varchar(100) NOT NULL,
upMax varchar(100) NOT NULL,
upYEAR Date NOT NULL,
upMi varchar(100)NOT NULL,
upIK varchar(100)NOT NULL
)
</code></pre>