Variable with Array of objects in Postgres

45 Views Asked by At

I'm trying to write sql which will create table and Index on specified columns. so i need something like 2 dimentional array with value like below -

-- tablename , keys (array of strings )

table_details:= {table1, 'column1, column2'}, {table2, 'column3'}

for each tabledetail from table_details

-- Create table 1st value from tabledetail 

   For each 2nd value from tabledetail  
       -- Create Index for all columns specified
   loop end 
loop end 
0

There are 0 best solutions below