how to to first check whether the table exist or not before creating it in postgresql?

user_264950 0
Viewed 428

How to check whether a table already exists or not before executing a creation script?

for example in MySQL database, we can do

IF NOT EXISTS tableName ..then create table sql script to follow

how about in PostgreSQL? Is there a way to check first if the table exists before creating it? How do we do it?

postgresql-9.1 create-table postgresql-9.3 syntax postgresql
1 Answers

PostgreSQL uses the following syntax:

CREATE TABLE IF NOT EXISTS mytable (
    -- Column definitions...
)
user_24227760
Related