Skip to content

Instantly share code, notes, and snippets.

@lucasdavila

lucasdavila/simple_pg_query_for_multitenant_dbs.sh

Created September 13, 2012 20:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lucasdavila/3717571 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lucasdavila/3717571 to your computer and use it in GitHub Desktop.
Download ZIP
Simple script to run a PostgreSQL query in multitenancy dbs
Raw
simple_pg_query_for_multitenant_dbs.sh
sql="select 1"
for tenant_name in tenant_1 tenant_2 tenant_3 tenant_4
do
psql -d $tenant_name -c "$sql"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment