1. pg_dump

pg_dump 导出 同时 去掉 public 符号

pg_dump -d d_test --inserts --column-inserts --quote-all-identifiers -T public.goose_db_version -T public.goose_db_version_id_seq | sed -e '/^--.*/d' -e '/^SET /d' -e '/^[[:space:]]*$/d' -e '/^SELECT pg_catalog./d' -e '/^ALTER TABLE .* OWNER TO "postgres";/d' -e 's/"public"\.//g' > /tmp/d_test.sql