Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- copy "SC_Tag"."tagdata_2015-01" ("F_TagName_ID", "F_Date", "F_ConvertedValue")
- to "SC_Tag"."tagdata_2015-01_new" (id_tag, f_time, value)
- INSERT INTO table_dest (fields_list) SELECT fields_list FROM table_src
- CREATE TABLE "SC_Tag"."tagdata_2015-01_new"
- ("id_tag", "f_time", "value")
- AS SELECT "F_TagName_ID", "F_Date", "F_ConvertedValue"
- FROM "SC_Tag"."tagdata_2015-01"
Add Comment
Please, Sign In to add comment