如何从PostgreSQL数据库中删除表*或*视图?

DROP TABLE user_statistics;

DROP VIEW user_statistics;

完整语法:

DROP TABLE

DROP VIEW

如果你想要一个完整的函数,我尝试了这样的方法:

CREATE OR REPLACE FUNCTION delete_table_or_view(objectName varchar) RETURNS integer AS $$
DECLARE
    isTable integer;
    isView integer;
BEGIN
    SELECT INTO isTable count(*) FROM pg_tables where tablename=objectName;
    SELECT INTO isView count(*) FROM pg_views where viewname=objectName;

    IF isTable = 1 THEN
        execute 'DROP TABLE ' || objectName;
        RETURN 1;
    END IF;

    IF isView = 1 THEN
        execute 'DROP VIEW ' || objectName;
        RETURN 2;
    END IF;

    RETURN 0;

END;
$$ LANGUAGE plpgsql;

考虑使用 删除表(如果存在) 和 删除视图(如果存在) 这样,如果失败,您就不会收到错误消息,只会收到通知。