/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 vote406 views1 answer
ModuleNotFoundError: No module named 'PySimpleGUI'
ActionScript
1 vote408 views2 answers
Mongodb docker
ActionScript
0 vote401 views4 answers
Iis appcmd stop site
ActionScript
0 vote352 views1 answer
Bs modal is working but not visible
ActionScript
0 vote419 views1 answer
Mass transit logging to seq
ActionScript
0 vote356 views1 answer
Reset udemy course
ActionScript
1 vote406 views1 answer
Move records from table to another using knex migration
ActionScript
0 vote416 views1 answer
Error: EROFS: read-only file system, mkdir '/user'
ActionScript
0 vote353 views1 answer
Mv ~/.npmrc ~/.npmrc.old npm prefix -g
ActionScript
0 vote365 views1 answer
Mount_osxfuse: /Users/em/mount_dev: Input/output error
ActionScript

Share