search

xataio / pgroll

PostgreSQL zero-downtime migrations made easy
https://www.xata.io
Apache License 2.0
3.59k stars 67 forks source link

Support for SQL generation #167

Open alisdairrankine opened 1 year ago

alisdairrankine commented 1 year ago

Hi there! I'm really interested in using this tool, however as a user of SQLc, I require the schema to be available as SQL. Is there any plan to support outputting the DDL as SQL?

andrew-farries commented 1 year ago

Thanks for opening the issue 👋

Do you mean that pgroll should be able to export the database schema as SQL CREATE TABLE statements so that SQLc can generate code for them?

If so, that's a little outside of our intended direction for pgroll right now, but we'll keep the issue open as it would be a useful option to have.

NefixEstrada commented 6 months ago

I have worked out a solution: https://github.com/xataio/pgroll/issues/269#issuecomment-2081295279