#!/bin/bash

# usage: ./make_indexes.sh <psql-command> <database>

PSQL=$1
DB=$2

$PSQL $DB -c "CREATE INDEX ON parent_table ((jsondata->'a'->'b'))" &
$PSQL $DB -c "CREATE INDEX ON parent_table ((jsondata->'c'->'d'))" &
$PSQL $DB -c "CREATE INDEX jsonexpr1 ON parent_table ((jsondata->'a'->'b'))" &
$PSQL $DB -c "CREATE INDEX jsonexpr2 ON parent_table ((jsondata->'c'->'d'))" &