/SQL/Create sequence if not exists postgres

Create sequence if not exists postgres

Create sequence if not exists postgres

CREATE SEQUENCE IF NOT EXISTS tbl_field_seq;

0

How to check if a sequence exists in postgresql

IF EXISTS (SELECT 0 FROM pg_class where relname = '<my sequence name here>' )
THEN
  --stuff here
END IF;

0

Source: stackoverflow.com

Similar codes

1 vote99 views1 answer
How to select random rows from table
SQL
0 vote106 views1 answer
Oracle sql generate list of days
SQL
2 votes112 views1 answer
Guid to string sql
SQL
0 vote92 views1 answer
Name '_mysql' is not defined
SQL
0 vote109 views1 answer
Comma seperated join mssql
SQL
0 vote109 views1 answer
Hex string sql becomes int64
SQL
1 vote103 views1 answer
ALL_TAB_PARTITIONS
SQL
4 votes128 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
25 votes119 views6 answers
How to change column name in mysql
SQL
0 vote105 views1 answer
Postgresql on conflict pair
SQL

Share