PostgreSQL schema migration?

postgresql schema-migration
Daulet Nurgali picture Daulet Nurgali · Feb 8, 2018 · Viewed 7.7k times · Source

I've local PostgreSQL database with tables, constraints, relations etc.

How can I migrate it to a production server?

Answer

sindhu_sp picture sindhu_sp · Feb 8, 2018

Try using flyway. It does exactly this. Dump your schema into an sql file and migrate using flyway.

Related questions

PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More
PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More