/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 vote492 views1 answer
Hello world in actionscript
ActionScript
0 vote510 views1 answer
Error: EROFS: read-only file system, mkdir '/user'
ActionScript
0 vote494 views2 answers
<%@ WebHandler Language="C#" CodeBehind="img.ashx.cs" Class="ReInsuranceSolution.Core.img" %>
ActionScript
1 vote513 views2 answers
How to disable foreign key constraint in postgresql
ActionScript
44 votes517 views2 answers
Btn-info color code
ActionScript
0 vote513 views1 answer
Mass transit logging to seq
ActionScript
1 vote518 views2 answers
Mongodb docker
ActionScript
4 votes479 views2 answers
Php get session variable from table
ActionScript
0 vote445 views1 answer
Mount_osxfuse: /Users/em/mount_dev: Input/output error
ActionScript
0 vote412 views1 answer
Hide or remove link on print
ActionScript

Share