postgresql批量删除表

发布时间：2020-12-13 16:11:49 所属栏目：百科来源：网络整理

导读：CREATE FUNCTION del_ora_table() RETURNS void AS $$ DECLARE tmp VARCHAR ( 512 ); DECLARE names CURSOR FOR select tablename from pg_tables where schemaname = ‘ public ‘ ; BEGIN FOR stmt IN names LOOP tmp : = ‘ DROP TABLE ‘ || quote_ident

CREATE FUNCTION del_ora_table() RETURNS void AS $$
DECLARE
    tmp VARCHAR(512);
DECLARE names CURSOR FOR 
    select tablename from pg_tables where schemaname=‘public‘;
BEGIN
  FOR stmt IN names LOOP
    tmp := ‘DROP TABLE ‘|| quote_ident(stmt.tablename) || ‘ CASCADE;‘;
    RAISE NOTICE ‘notice: %‘,tmp;
    EXECUTE ‘DROP TABLE ‘|| quote_ident(stmt.tablename) || ‘ CASCADE;‘;
  END LOOP;
  RAISE NOTICE ‘finished .....‘;
END;
 
$$ LANGUAGE plpgsql;

--执行函数批量删除表
select del_ora_table();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!