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";
						
						
					  
					  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