Project

General

Profile

Download (278 Bytes) Statistics
| Revision:

root/inputs/FIA/REF_SPECIES/postprocess.sql @ 8098

1 8093 aaronmk 
SELECT functions.to_global_col_names(:table_str);
2 

      

      

        3
        
            8098
        
        
            aaronmk
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "REF_SPECIES" RENAME "REF_SPECIES.SPCD" TO ".SPCD"$$);


      

      

        4
        
        
        
        
        

      

      

        5
        
        
        
        
        
SELECT functions.create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE (".SPCD")$$);