Support for `postgresql_databases` data source

[igor-nikiforov]

Hello,

I have a requirement where I'm need to get a list of all databases from current PG instance and use it to create another non-PG related resources for each of database.

In PG it could be done with simple SQL query:

SELECT datname FROM pg_catalog.pg_database;

Example of data resource:

data "postgresql_databases" "this" {}

Result:

[db1, db2, db3]

Additionally, nice to have in-build regex filter to omit default databases like postgres, template0 and template1.

[joaocc]

This would indeed be great. This was one of the few points we found lacking when looking at this fine provider. In order to be able to use terraform to things like "ensuring PUBLIC is not granted connect on any existing database" or other such scenarios.
Do you know if there is any sponsor program for this provider? Thx

[tide-jamiegwatkin]

I'm also looking for this, our usecase is we use Terraform to spin up database instances (AWS RDS) but we use other tooling to create the databases themselves. It would still be useful to see all those databases that have been created by external tooling.