PostgreSQL allows NULL values to be stored in table columns, which represent the absence of a value. When querying a table with NULL values, special operators like IS NULL and IS NOT NULL can be used to filter the results.