Answers for "if not exists then create table in postgres"

postgres create database if not exists

SELECT 'CREATE DATABASE mydb'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'mydb')gexec

Posted by: Guest on June-02-2021

how to check table exists or not in postgresql

SELECT 1 FROM information_schema.tables
WHERE table_schema = 'schema_name'	AND table_name = 'table_name';

Posted by: Guest on June-24-2020

Code answers related to "if not exists then create table in postgres"