1
Download Icon
Transcript
Using WFS-T in combination with geolocation for online transactional editing of geographic features through mobile browsers B PostgreSQL with PostGIS Issues PostgreSQL supports capital letters in table and column names, but it requires them to be quoted in queries. Table 6 shows some examples of how the results return when the table names are "norway" and "Norway". Table Name norway Norway SQL command select * from norway; select * from norway; Norway select * from Norway; Norway select * from "Norway"; Result Success ERROR: relation "norway" does not exist SQL state: 42P01 ERROR: relation "norway" does not exist SQL state: 42P01 Success Table 6: Query problem in PostgreSQL 49
