title: “Copy a Postgres Table from one DB to another”
date: 2021-05-05T08:01:15
slug: 1669-2

Export and base64 Encode Table “replication_policy” from Database “regstry”

pg\_dump -C -a -t replication\_policy -d registry | base64 -w 0 >/tmp/table\_dump

Copy thae base64 File to the other DB and import it:

cat /tmp/table\_dump | base64 -d | psql registry