Project

General

Profile

Download (378 Bytes) Statistics
| Revision:

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

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
        
            8112
        
        
            aaronmk
        
        
SELECT functions.set_col_types(:table_str, ARRAY[


      

      

        6
        
        
        
        
        
  ('.SPCD', 'integer')


      

      

        7
        
        
        
        
        
]::functions.col_cast[]);


      

      

        8
        
        
        
        
        

      

      

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