[TOC] ## 增刪改查 實例為對數組的操作 ``` // 創建表 CREATE TABLE "sal_emp" ( "name" text , "pay_by_quarter" int[], "schedule" text[][] ) // 插入 insert into sal_emp VALUES('a','{1,2,3}','{{"a","b","c"},{"d","e","f"}}') // 更新,注意: postgresql 數組索引從1開始 update sal_emp set pay_by_quarter[1]=123 // 獲取 select pay_by_quarter from sal_emp // {123,2,3} select pay_by_quarter[1] from sal_emp // 123 ``` ## SELECT INTO ,從一張表插入另一張 語法 ``` SELECT column_list INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table [other_clauses] ``` 示例 ``` SELECT title INTO TABLE film_ranting_g_title FROM film WHERE rating = 'G'; ``` 把評分為G 的表遷移到另一張表中