/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

0 vote314 views1 answer
Savepoint mysql script
SQL
33 votes297 views6 answers
Change column name in mysql
SQL
9 votes328 views3 answers
Find all tables with column name
SQL
2 votes301 views1 answer
Update with join sql server
SQL
0 vote286 views1 answer
Download mysql database to excel in android studio
SQL
16 votes301 views1 answer
Sql comment'
SQL
0 vote299 views1 answer
How to reset table in sql server
SQL
6 votes322 views2 answers
Sql sequence
SQL
3 votes287 views1 answer
Sql server check version
SQL
3 votes296 views1 answer
Sql server version query
SQL

Share