2021-08-30 【PostgreSQL】 Cheat sheet 77 0 PostgreSQL PostgreSQL Cheat sheet 列出所有tableSELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE';將SELECT 的結果存入新的資料表SELECT "Column1" INTO TABLE "NewTable" FROM "Table1"; PostgreSQLCheat sheet 回首頁