Create sequence if not exist in DuckDB

Question

It seems like DuckDB does not support this:

CREATE SEQUENCE seq_personid START 1 IF NOT EXIST;

Postres has this feature https://www.postgresql.org/docs/current/sql-createsequence.html

What would be the best workaround if DuckDB does not support this?

Answer 1

I don't think you are using the if not exists correctly.

It should be:

CREATE SEQUENCE IF NOT EXISTS seq_personid START 1;