pgsql 用一个csv文件的数据，去表中查询结果并导出

1. 创建临时表

CREATE TEMP TABLE tmp_uids (user_id BIGINT PRIMARY KEY);

2. 把csv数据导入到临时表中

\copy tmp_uids FROM '/tmp/uids_goods_20251215.csv' CSV;

3. 生成数据（去重）到/tmp/result_goods_ids.csv

\copy (SELECT DISTINCT b.goods_id FROM tmp_uids t JOIN public.goods b ON b.user_id = t.user_id AND b.goods_id != 0 ORDER BY b.goods_id) TO '/tmp/result_goods_ids.csv' WITH (FORMAT CSV, HEADER FALSE, ENCODING 'UTF8');

4. 生成数据（不去重）到/tmp/result_goods_ids.csv

\copy (SELECT b.goods_id FROM tmp_uids t JOIN public.goods b ON b.user_id = t.user_id AND b.goods_id != 0 ORDER BY b.goods_id) TO '/tmp/result_goods_ids.csv' WITH (FORMAT CSV, HEADER FALSE, ENCODING 'UTF8');

5. 删除临时表

DROP TABLE IF EXISTS tmp_uids;