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