[postgis-users] Quoting column names in MapServer PostGIS Support

[Timothy H. Keitt]

I meant I was translating the dots in R names
("some.dataframe$my.column.name") into underscores in postgresql names
("some_table.my_column_name"), not the other way around. Actually, you
can use underscores in R names and dots in postgresql names, you just
have to quote around them.

Tim

On Thu, 2002-05-16 at 15:23, Adrian Custer wrote:
> On Thu, 2002-05-16 at 07:35, Timothy H. Keitt wrote:
> > It depends somewhat on whether you will only every access the database
> > via the name substitution interface, or whether you might also query the
> > from another program. I implemented a postgresql interface in R and
> > initially did some name translation (R traditionally uses "." as a
> > separator and I substituted them with "_"). 
> 
> I presume you understand that the underscore is an operator?
> 
> 
> a_c(1,2,3,4) 
> 
> is the same as 
> 
> a <- c(1,2,3,4)
> 
> so that substitution might be a tad dangerous.
> 
> :-)
> 
> -adrian
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users