Project

General

Profile

« Previous | Next » 

Revision 8093

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/FIA/*/postprocess.sql: Use functions.to_global_col_names() to ensure that all column names are globally unique. This makes it easy to join the tables together without worrying about column name collisions.

View differences:

postprocess.sql
1 
SELECT functions.create_if_not_exists($$ALTER TABLE "PLOT" ADD CONSTRAINT "PLOT.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR")$$);
1 
SELECT functions.to_global_col_names(:table_str);
2 

  		




  
  3
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "PLOT" ADD CONSTRAINT "PLOT.unique" UNIQUE ("PLOT.STATECD", "PLOT.UNITCD", "PLOT.COUNTYCD", "PLOT.PLOT", "PLOT.INVYR")$$);


  		












Also available in:  Unified diff