Onega

a lot of VC++ posts, a few C# posts, and some miscellaneous stuff

Tuesday, February 01, 2005

table/field name in PostgreSQL

I found an interesting fact with PostgreSQL
name of some table/field must be quoted, otherwise psql complains relation image not exist.
Create or replace VIEW IMAGE_(EXPOSURE_TIME,XRAY_CURRENT,
)
as select Exposure_time,"Xray_tube_current",
from "IMAGE";

0 Comments:

Post a Comment

<< Home