Example Select the hard coded string field and assign the field name SELECT 'Hard coded status' AS status; Reference PostgreSQL: Documentation: 15: SELECT sql - Include in SELECT a column that isn’t actually in the database - Stack Overflow