SQL query in source code

Topics: SharpMap Project
Jul 25, 2013 at 12:31 PM
Dear all,

I have a small question to ask:

When I read the source code designed to read data from postgres in SharpMap PostGIS class. I find the query codes are
var strSQL = "SELECT \"" + ObjectIdColumn + "\" ";
strSQL +="FROM" + QualifedTable + "WHERE ";
I don't understand why not use

var strSQL ="SELECT" + ObjectIdColumn +"FROM" + QualifedTable + "WHERE" ?

Why there are some "\" " and what does this mean? Any guidance?

Many thanks!
Coordinator
Jul 25, 2013 at 3:06 PM
The columns should be placed in double-quotes to mark them as identifiers. Otherwise you cannot use capital letters in your column names.


Hth FObermaier
Aug 5, 2013 at 8:57 AM
In fact, the quotes are for "special characters" on column names, such as spaces or symbols. SQLServer also supports the brackets, but I think the quotes are ANSI SQL code