[TOC] ## 連接 數據庫 ``` psql -d dbname -U user -W // or psql -h host -p port -d dbname -U user -W ``` ## 常用命令 ### 列出所有的數據庫 ``` \l // or \l ``` ### 進入數據庫 ``` \c web_db ``` ### 列出數據庫中的表 ``` \dt // or \dt+ ``` ### 查看表結構 ``` \d table_name ``` ### 開啟查詢執行時間 ``` \timing select * from product; ``` ### 查看命令歷史 ``` \s ``` ### 語法幫助 ``` \h sql_command ``` 如 ``` \h select ``` ### 從文件中執行 psql 命令 ``` \i filename ``` 如 ``` \i C:/data/my.sql ``` ### 查詢數據 ``` > \x > select * from product; -[ RECORD 1 ]+------------------------------------------------------------- id | 2 product_name | Shirt B attributes | "Color"=>"White", "Style"=>"Business", "Season"=>"Spring" -[ RECORD 2 ]+------------------------------------------------------------- id | 1 product_name | Computer A attributes | "CPU"=>"2.5", "Disk"=>"1T", "Brand"=>"Dell", "Memory"=>"16G" ```