postgres: how to create table "if not exists" but ONLY if the schemas match?

Question

IF NOT EXISTS

Do not throw an error if a relation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing relation is anything like the one that would have been created.

often we don't care if just the name matches, we care if the schema matches. is there any way specify "if not exists" but checking that the schema also matches?

JGH · Accepted Answer · 2021-07-05 13:43:19Z

5

You can specify the schema name in the table creation statement

CREATE TABLE IF NOT EXISTS myshema.mytable AS ...

answered Jul 5, 2021 at 13:43

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres: how to create table "if not exists" but ONLY if the schemas match?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related