On Thu, 26 Jul 2001, G.L. Grobe wrote:
> When creating an incremental and unique id, what are the benefits of using:
>
> CREATE TABLE tablename (colname SERIAL);
>
> instead of :
>
> CREATE SEQUENCE tablename_colname_seq;
> CREATE TABLE tablename
> (colname integer DEFAULT nextval('tablena
They are both the same, as far as I know. I usually make my table
definition file like this:
DROP SEQUENCE mytable_number_seq;
DROP TABLE mytable;
CREATE TABLE mytable (
number SERIAL
);
---(end of broadcast)---
TIP 1: subscribe and unsub
