b:[["$","div",null,{"className":"w-full bg-center bg-cover h-96","style":{"backgroundImage":"url(https://strapi.im-neko.net/uploads/IMG_1313_e1574080712559_347fec2928.jpg)"},"children":["$","div",null,{"className":"flex items-center justify-center w-full h-full text-4xl text-white font-bold lg:text3xl","children":"postgresの特定のデータベースのテーブルを全部消す"}]}],["$","div",null,{"className":"flex flex-row-reverse justify-between m-2","children":[["$","div",null,{"className":"font-semibold text-gray-400 undefined","children":["$","a",null,{"className":"text-blue-400","href":"/category/tech","children":"#tech"}]}],["$","div",null,{"className":"font-semibold text-gray-400 undefined","children":"2023 / 3 / 26"}]]}],["$","article",null,{"className":"znc justify-center m-8 sm:m-8 md:m-12 lg:m-24 font-body","children":["$","div",null,{"dangerouslySetInnerHTML":{"__html":"

メモ

同じschemaに複数のプロジェクトのデータがあったりするとググってよく出てくるschema毎dropみたいなのがやりにくいので以下のクエリで削除用のクエリを作る

SELECT\n  'DROP TABLE IF EXISTS \"' || tablename || '\" CASCADE;' \nfrom\n  pg_tables WHERE schemaname = 'public';\n

"}}]}]]