I was trying to keep all the queries(create, drop, alter) in a function. And 'll call the function when required. But i got below error "CREATE INDEX CONCURRENTLY cannot be executed from a function or multi-command string"
CIC can't be executed inside a transaction block or a user-defined function because it involves some phases that are not easily rollback-able. Instead create a small script with those commands.