Eine Einführung in

SQL

SELECT a column whose name contains spaces?

PostgreSQL
If I have a column whose name contains a space, e.g. "Account Balance", I can't seem to select it. SELECT Account Balance FROM MyTable gets an error SELECT 'Account Balance' FROM MyTable also gets an error. What should I do?


Specific to PostgreSQL
Use double quotes - better yet - don't put spaces in field names.