摘要:
创建一个函数 创建一个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... 阅读全文
摘要:
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) || ... 阅读全文