Postgres GENERATED BY DEFAULT AS IDENTITY (sequence_options)

Question

The Postgres documentation CREATE TABLE says for GENERATED BY DEFAULT AS IDENTITY (sequence_options) that:

The optional sequence_options clause can be used to override the options of the sequence. See CREATE SEQUENCE for details.

The documentation CREATE SEQUENCE no longer calls them as options but parameters. Anyway, the name is also listed as a parameter. The examples are rather taciturn. Is it possible to override the name of the sequence that will be created for an identity column?

gemisigo · Accepted Answer · 2022-06-09 22:01:00Z

5

It turned out the answer is yes, there is a way. The twist is that while it is obvious you're giving sequence options between the parenthesis, simply saying NAME xyz is not enough, you still have to tell postgres that the name you provide is SEQUENCE NAME:

CREATE TABLE test(
    i int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY(SEQUENCE NAME xyz START WITH 1)
) ;

answered Jun 9, 2022 at 22:01

gemisigo

2751 gold badge5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres GENERATED BY DEFAULT AS IDENTITY (sequence_options)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related