Question

How to store boolean values in PostgreSQL?

  • 4 November 2021
  • 2 replies
  • 24 views

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 +8

Hi @isaiah.taylor 

It should work, can you try with and without the quotation mark? Here are the accepted values: https://www.postgresql.org/docs/9.1/datatype-boolean.html

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