SQL Not Empty instead of Not NULL

sql postgresql notnull
kamaci picture kamaci · Oct 31, 2011 · Viewed 20.5k times · Source

I am using postgreSQL. I have a column that:

NOT NULL

However when I want to insert a row with an empty string as like:

''

it doesn't give me an error and accepts. How can I check insert value should be not empty? (Neither empty nor null)

PS: My column defined as:

"ads" character varying(60) NOT NULL

Answer

Avo Muromägi picture Avo Muromägi · Oct 31, 2011

Add a constraint to column definition. For example something like:

ads character varying(60) NOT NULL CHECK (ads <> '')

For more, see http://www.postgresql.org/docs/current/static/ddl-constraints.html

Related questions

How to drop all NOT NULL constraints from a PostgreSQL table in one go

Is it possible to drop all NOT NULL constraints from a table in one go? I have a big table with a lot of NOT NULL constraints and I'm searching for a solution that is faster than dropping them separately.

Read More
PostgreSQL - empty values that are not null and not empty strings

I ran this query on a PostgreSQL table: select * wkt from table where column <>'' and column is not null ..and unexpectedly received several rows with no visible value in that column. Why is this? Is there some …

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More