postgresql 删除所有表

CREATE FUNCTION aaa() RETURNS void AS $$DECLAREtmp VARCHAR(512);DECLARE names CURSOR FORselect tablename from pg_tables where schemaname='public';BEGINFOR stmt IN names LOOPtmp ...

一万小时_now

4169人浏览 · 2020-03-06 11:29:57

一万小时_now · 2020-03-06 11:29:57 发布

CREATE FUNCTION aaa() 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 aaa();

CSDN学习社区

CSDN联合极客时间，共同打造面向开发者的精品内容学习社区，助力成长！

更多推荐