摘要: 创建一个函数 创建一个trigger, 将表和函数绑定 ALTER TRIGGER trigger_name ON table_name RENAME TO new_name; ALTER TRIGGER last_name_changes ON employees RENAME TO log_last_name_changes; ALTER TABLE table_name DISA... 阅读全文
posted @ 2016-04-24 11:47 songlihong 阅读(157) 评论(0) 推荐(0) 编辑
摘要: CREATE OR REPLACE view_name AS query DROP VIEW [ IF EXISTS ] view_name; 一个复杂的 query: SELECT cu.customer_id AS id, (((cu.first_name)::text || ' '::text) || ... 阅读全文
posted @ 2016-04-24 10:32 songlihong 阅读(160) 评论(0) 推荐(0) 编辑