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](https://stackoverflow.com/questions/13223820/postgresql-delete-all-content) — Scoots, Dec 24 '19 at 11:15

score 1 · Answer 1 · answered Dec 25 '19 at 12:54

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 '19 at 12:54

exanoid

31
4

Does above command affect other rows and fields in that table? – Solomon Raja Jan 20 '21 at 16:36

Delete bytea data from Postgresql

1 Answers1