wiki:PostGreSQL

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');

Last modified 13 years ago Last modified on Feb 17, 2011, 4:32:19 PM