/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

1 vote294 views2 answers
Mongodb docker
ActionScript
0 vote244 views1 answer
ERROR: syntax error at or near "IF"
ActionScript
0 vote243 views1 answer
Reset udemy course
ActionScript
0 vote247 views1 answer
Apache bench windows 10
ActionScript
0 vote246 views2 answers
When o am opening my bs modal all background content is shifting a little left everytime
ActionScript
0 vote260 views2 answers
Docker compose enable rabbitmq enable plugins
ActionScript
-9 votes248 views3 answers
Download debian
ActionScript
1 vote285 views1 answer
Rabbitmq docker can access website
ActionScript
0 vote255 views1 answer
Hide or remove link on print
ActionScript
0 vote280 views1 answer
From sys import stdin
ActionScript

Share