PostgreSQL 中 不想让数据插入到某个表应该怎么做?

好

创建do instead nothing规则, 例如
digoal=> create rule r_insert as on insert to test do instead nothing;
CREATE RULE
digoal=> insert into test values (1);
INSERT 0 0
digoal=> select * from test ;
 id 
----
(0 rows)

以上方法对COPY无法生效，因为COPY不走重写规则。
要让所有数据都无法进入，可以用行触发器。
pipeline=# create or replace function tg() returns trigger as 
$$

pipeline$# declare
pipeline$# begin
pipeline$#   return null;
pipeline$# end;
pipeline$# 
$$
 language plpgsql;

pipeline=# create trigger tg1 before insert on tbl for each row execute procedure tg();
CREATE TRIGGER

pipeline=# \d tbl
      Table "public.tbl"
 Column |  Type   | Modifiers 
--------+---------+-----------
 v_d    | date    | 
 data   | numeric | 
 month  | numeric | 
 year   | numeric | 
Triggers:
    tg1 BEFORE INSERT ON tbl FOR EACH ROW EXECUTE PROCEDURE tg()

pipeline=# insert into tbl values ('2015-01-01');
INSERT 0 0

pipeline=# copy tbl from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> '2015-01-01' \N      \N      \N  
>> \.
COPY 0