Editing PostGreSQL

* Editing Values in a complete Column:

  update mpdl.songy_tiang_zh_1637 set source_link = overlay(source_link placing 'http://echo.mpiwg-berlin.mpg.de/ECHOdocuView' from 1 for 48)

* Adding new Views:

CREATE OR REPLACE VIEW tiangong_kaiwu_chap12_oilfat AS 
 SELECT *  FROM mpdl.songy_tiang_zh_1637
  WHERE CAST(mpdl.songy_tiang_zh_1637.page AS numeric) >= 297 AND CAST(mpdl.songy_tiang_zh_1637.page AS numeric) <= 310;

ALTER TABLE  tiangong_kaiwu_chap12_oilfat OWNER TO postgres;

Insert into gis_table_meta_rows values
(DEFAULT,'tiangong_kaiwu_chap12_oilfat','gis_id_point','gis_id'),
(DEFAULT,'tiangong_kaiwu_chap12_oilfat','latitude','coord_lat'),
(DEFAULT,'tiangong_kaiwu_chap12_oilfat','longitude','coord_lon');

Insert into gis_table_meta values
(DEFAULT,'postgres','mpdl','Song Yingxing: Tiangong Kaiwu, Chapt. 12, Oils and Fats','tiangong_kaiwu_chap12_oilfat','2011-02-17','2011-02-17');