On Fri, 17 Mar 2006, loki wrote: > Hi, > i'm just starting with postgres DB, but this looks very strange to me: > > If i try to create table with collumn user, it fails with error: > create exec error:ERROR: syntax error at or near "user" at character 368 USER is a reserved word in SQL and as such cannot be used as a non-quoted identifier so "user" (with the quotes) should work, however you'd probably have to use the quotes in all cases. Technically, we allow some reserved words as non-quoted identifiers in some places, however to be compliant to spec you cannot use any of the reserved words that way.
