Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Postgresql: pg_dump what are [large objects]

I was trying to do a backup using pg_dump. There is an option keep me wondering.

According to pg_dump --help

 -b, --blobs                  include large objects in dump  

I try looking for blobs, but only got info regarding BYTEA

http://www.postgresql.org/docs/9.1/static/datatype-binary.html

so what are large objects ?

like image 438
Juan Carlos Oropeza Avatar asked Aug 01 '26 07:08

Juan Carlos Oropeza


1 Answers

http://postgresql.org/docs/current/static/largeobjects.html

Thanks this answer my question.

I just got a negative vote for my question.
In my defense i search for posgres BLOB and only find info about the BYTEA column, but not about the definition of LARGE OBJECT

like image 133
Juan Carlos Oropeza Avatar answered Aug 04 '26 01:08

Juan Carlos Oropeza



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!