Delete bytea data from Postgresql

Question

I'm using Openerp 7.0 and there are so many file that has been uploaded to that database I want to delete every file that has been uploaded. The Openerp is storing the data in a table called ir_attachment and a column db_datas that has type bytea.

So how do i delete every value from db_datas?

Does this answer your question? PostgreSQL delete all content — Scoots
– Scoots, Commented Dec 24, 2019 at 11:15

exanoid · Accepted Answer · 2019-12-25 12:54:41Z

1

I actually need to vacuum after i set everything to null

update ir_attachment set db_datas = NULL;

VACUUM (VERBOSE, FULL) ir_attachment;

answered Dec 25, 2019 at 12:54

exanoid

315 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Solomon Raja Over a year ago

Does above command affect other rows and fields in that table?

Collectives™ on Stack Overflow

Delete bytea data from Postgresql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related