Project

General

Profile

« Previous | Next » 

Revision 12648

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/vegbien.sql: public_validations schema comment: added instructions to change the key and value columns for a validations query

View differences:

vegbien.sql
32 32 

  		




  33
  33
  
    
to remove a validations query so its columns can be changed:


  		




  34
  34
  
    
SELECT public_validations.rm_query_view(''public_validations._view_name'');


  		




  
  35
  
    

  		




  
  36
  
    
to change the key and value columns for a validations query:


  		




  
  37
  
    
DROP   TYPE public_validations."keys_~type._view_name"    CASCADE;


  		




  
  38
  
    
CREATE TYPE public_validations."keys_~type._view_name"    AS (key_cols);


  		




  
  39
  
    
DROP   TYPE public_validations."values__~type._view_name" CASCADE;


  		




  
  40
  
    
CREATE TYPE public_validations."values__~type._view_name" AS (value_cols);


  		




  
  41
  
    
SELECT public_validations.remake_diff_table(''"datasource"._view_name'');


  		




  35
  42
  
    
';


  		




  36
  43
  
    

  		




  37
  44
  
    

  		












Also available in:  Unified diff