aboutsummaryrefslogtreecommitdiff
path: root/src/createIndexQuery.sql
blob: a4e271285bb433b16c130750f5021a5504184bf8 (plain) (blame)
1
2
3
4
5
SELECT
  'CREATE INDEX CONCURRENTLY ' || table_name || '_' || column_name || ' ON ' || table_name || ' ("' || column_name || '");' 
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name = 'vmadd';