Redgate Flyway

For PostgreSQL users - where are your DBs hosted?

Flyway Tablespace Setting

Description

The tablespace in which to create the schema history table that will be used by Flyway.

This setting is only relevant for databases that do support the notion of tablespaces. Its value is simply ignored for all others.

Type

String

Default

Flyway uses the default tablespace for the database connection

Usage

Flyway Desktop

This can't be set in a config file via Flyway Desktop, although it will be honoured, and it can be configured as an advanced parameter in operations on the Migrations page.

Command-line

./flyway -tablespace="xyz" info

TOML Configuration File

[flyway]
tablespace = "xyz"

Configuration File

flyway.tablespace=xyz

Environment Variable

FLYWAY_TABLESPACE=xyz

API

Flyway.configure()
    .tablespace("xyz")
    .load()

Gradle

flyway {
    tablespace = 'xyz'
}

Maven

<configuration>
    <tablespace>xyz</tablespace>
</configuration>

Didn't find what you were looking for?