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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
