Thread: pgAdmin with a driver to run Sql statements over multiple databases
Hi
Is it possible for pgAdmin to execute SQL statements over multiple databases?
As an example, if one has done horizontal sharding with Databas01, Database02...DatabaseN having the same schema and the data spread over the cluster. Is it possible to configure pgAdmin to distribute the Sql requests to all databases and reduce the results?
Thank you
Re: pgAdmin with a driver to run Sql statements over multiple databases
From
Guillaume Lelarge
Date:
Hi, On Tue, 2013-06-04 at 13:57 -0700, Matthieu Labour wrote: > [...] > Is it possible for pgAdmin to execute SQL statements over multiple > databases? > > As an example, if one has done horizontal sharding with Databas01, > Database02...DatabaseN having the same schema and the data spread over the > cluster. Is it possible to configure pgAdmin to distribute the Sql requests > to all databases and reduce the results? > pgAdmin is just an admin tool. It will execute the query to the database you're connected to. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com