参考手册

参考手册

实例 PostgreSQL 使用 WHERE 等于的条件实例

 
SELECT * FROM customers
WHERE customer_id = 19;        
                    

输出结果

 customer_id |   customer_name    | contact_name |    address     |  city  | postal_code | country
-------------+--------------------+--------------+----------------+--------+-------------+---------
          19 | Eastern Connection | Ann Devon    | 35 King George | London | WX3 6FW     | UK
(1 row)