reshape

postgres migration

Creating a table


[[actions]]
type = "create_table"
name = "users"

	[[actions.columns]]
	name = "id"
	type = "INTEGER"
	generated = "ALWAYS AS IDENTITY"

	[[actions.columns]]
	name = "name"
	type = "TEXT"

Renaming a column


[[actions]]
type = "alter_column"
table = "users"
column = "name"

	[actions.changes]
	name = "full_name"

reshape

fabianlindfors • Updated 2023 Aug 30 9:12

Fabian Lindfors

About six months back, I wrote a post on how to use views in Postgres to encapsulate tables and create a versioned interface to a database. At the end of the post, I mentioned working on a tool to automate zero-downtime migrations using this technique and I've finally released something, albeit experimental.

https://fabianlindfors.se/blog/schema-migrations-in-postgres-using-reshape/

reshape

Creating a table

Renaming a column

Recommendations