NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
FROM imsmaenum, ...
WHERE imsmaenum.enumvalue = 'Progress Report';
</pre>
Similarly, in mySQL it is possible to define column names with a mix of upper and lower case as well as blanks and other special characters without any trouble. In PostgreSQL, this is also possible, but in this case the column name '''must''' be enclosed in double quotes. For example, the following create view statement:<br />
'''mySQL'''
<pre>
CREATE VIEW my_view AS
SELECT hazreducdeviceinfo.hazreduc_guid AS hazreduc_guid,
ordnance.model AS Device Type
FROM hazreducdeviceinfo;
</pre>
needs to be changed to:<br />
'''PostgreSQL'''
<pre>
CREATE VIEW my_view AS
SELECT hazreducdeviceinfo.hazreduc_guid AS hazreduc_guid,
ordnance.model AS "Device Type"
FROM hazreducdeviceinfo;
</pre>