Changeset 245


Ignore:
Timestamp:
01/31/13 09:36:34 (8 years ago)
Author:
astrid.emde
Message:

View upper case, Comment on View, Test steht aus

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/pg-to-oci_keytables.pl

    r241 r245  
    3131open I, "alkis_PostNAS_keytables.sql"; 
    3232open O, ">alkis_PostNAS_ORACLE_keytables.sql"; 
     33#open I, "nutzungsart_definition.sql"; 
     34#open O, ">nutzungsart_definition_ORACLE.sql"; 
     35#open I, "nutzungsart_laden.sql"; 
     36#open O, ">nutzungsart_laden_ORACLE.sql"; 
     37#open I, "pp_definition.sql"; 
     38#open O, ">pp_definition_ORACLE.sql"; 
     39#open I, "pp_laden.sql"; 
     40#open O, ">pp_laden_ORACLE.sql"; 
     41#open I, "sichten.sql"; 
     42#open O, ">sichten_ORACLE.sql"; 
    3343 
    3444$i = 0; 
     
    107117        s/INSERT INTO (\S+)/INSERT INTO \U$1\E/; 
    108118 
     119        # View Tabellennamen in uppercase 
     120        s/CREATE OR REPLACE VIEW (\S+)/CREATE OR REPLACE VIEW \U$1\E/; 
     121 
     122        # View Comment in uppercase 
     123        s/COMMENT ON VIEW (\S+)/COMMENT ON VIEW \U$1\E/;  
     124 
    109125        next if /^COMMENT ON TABLE (geometry_columns|spatial_ref_sys)/; 
    110126 
Note: See TracChangeset for help on using the changeset viewer.