Hi,Of course pg_dump can also dump blobs, and it's even the default. You may use the option --no-blobs to leave them out.
A glance at the man page can be more informative than just hearing something from someone.
Regards, Holger Am 06.11.20 um 23:02 schrieb Ron Watkins:
Newbie to postgres here. We have Postgres 11 server at work and we need to copy a database contents from a TEST server to a PROD server. I was looking at pg_dump, but I heard it doesn't work with binary (blob) data? Can someone clarify how to copy a database contents from one server to another server?Ron
-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment:
OpenPGP_0x8A579C93B31961BA.asc
Description: application/pgp-keys
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature