/ActionScript/How to check if a sequence exists in postgresql

How to check if a sequence exists in postgresql

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 vote366 views2 answers
Docker compose enable rabbitmq enable plugins
ActionScript
1 vote434 views2 answers
Mongodb docker
ActionScript
4 votes407 views2 answers
Php get session variable from table
ActionScript
0 vote360 views1 answer
Bs modal is working but not visible
ActionScript
0 vote374 views1 answer
Read pdf web on android
ActionScript
1 vote427 views1 answer
Move records from table to another using knex migration
ActionScript
4 votes333 views1 answer
Media queries for all devices
ActionScript
1 vote415 views1 answer
How can I get the status code from an http error in Axios?
ActionScript
10 votes463 views6 answers
Brew start postgres
ActionScript
44 votes446 views2 answers
Btn-info color code
ActionScript

Share