On 7/13/22 07:58, André Hänsel wrote:
> Jeremy Smith wrote:
> CREATE TABLE t (
>
> id serial PRIMARY KEY,
>
> name text NOT NULL UNIQUE,
>
> address text NOT NULL
>
> );
>
> This will yield “8”, showing that new sequence numbers have been
> generated for each attempt.
>
If running out of id's is a concern use bigserial instead of serial as
it uses bigint:
bigint -9223372036854775808 to +9223372036854775807
vs
integer for serial:
integer -2147483648 to +2147483647
--
Adrian Klaver
adrian.klaver@aklaver.com