database - postgresql 中 CREATE VIEW IF NOT EXISTS 的等价物是什么

Question

我想做类似的事情

CREATE VIEW IF NOT EXISTS complete_user_profile ...

不知道怎么样

Answer 1

你可以使用 CREATE OR REPLACE :

CREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced. The new query must generate the same columns that were generated by the existing view query (that is, the same column names in the same order and with the same data types), but it may add additional columns to the end of the list. The calculations giving rise to the output columns may be completely different.

CREATE OR REPLACE VIEW complete_user_profile ...