SQL Connect should support more postgreSQL constraints and indexes
Customers that have an existing schema with PostgreSQL or have product requirements that involve using more complex PostgreSQL features like CHECK constraints or partial indexes cannot use fdc because it tries to drop the schema and fails to start up.
There's partial support for this already via the brownfield setup guide but if constraints and indexes could be included this would unlock more use cases. https://firebase.google.com/docs/sql-connect/manage-services-and-databases#integrate-existing-databases
See the issue here https://github.com/firebase/firebase-tools/issues/10571
1
vote
Aaron Zhang
shared this idea