Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for postgresql_view resource #375

Open
nguyen1tech opened this issue Nov 29, 2023 · 2 comments
Open

Support for postgresql_view resource #375

nguyen1tech opened this issue Nov 29, 2023 · 2 comments
Labels

Comments

@nguyen1tech
Copy link

Hi,

In our PG database, there are a lot of views and it is hard to manage them. We're thinking if we can use Terraform to manage all the views in our PG database but after searching around I could not find something like postgresql_view resource.
Can we add suport for postgresql_view resource to the provider?

resource "postgresql_view" "my_pg_view" {
      name = "my_pg_view"
      schema = "my_pg_schema"
      query = <<EOF
        SELECT * FROM users WHERE age > 30;
      EOF
}

Thanks!

@AndrewJackson2020
Copy link

Plus one for this feature request. Views are perfect to be deployed via terraform because they have no data.

@nguyen1tech
Copy link
Author

I have created a PR for it here: #442 It's waiting for review now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants