How do I set field value to null?

rap2hpoutre / pg-anonymizer

Dump anonymized PostgreSQL database with a NodeJS CLI

https://raph.site

MIT License

223 stars 31 forks source link

Closed mangvlad closed 2 years ago

mangvlad commented 2 years ago

Looking to clear some columns but am not sure about the syntax. Thanks!

mangvlad commented 2 years ago

It appears that something like this works: contact_note:'\N' (so \N is what pg_dump is using as NULL)

mangvlad commented 2 years ago

Using '\N' works