How to store boolean values in PostgreSQL?

  • 4 November 2021
  • 2 replies

I can’t figure out how to create a new row that has a Boolean value with the PostgreSQL plugin. I’ve tried “TRUE”, “true”, and 1 in the field, to no avail.

Here’s the field I’m trying to set:


Here’s what it looks like before I test:

And here’s what I get back from Zapier:


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

Hi @isaiah.taylor 

It should work, can you try with and without the quotation mark? Here are the accepted values:

Sorry, original post was confusing. I was not using quotes.