$50 Metal Postgres databases are here. Learn more
Navigation

New columns flag for pscale dump

You can now export specific columns from your tables when using the pscale database dump command. The new --columns flag lets you specify which columns to include for each table, giving you more control over your database exports.

This is useful when you need a partial export or want to exclude sensitive data from your dumps.

# Export only specific columns from multiple tables
pscale database dump my-database main --columns 'users:id,name' --columns 'orders:id,total'

The format is table:column1,column2, and you can specify the flag multiple times for different tables. The schema dump will include the complete table schema, but the data files will only contain the specified columns.

This feature is available for Vitess databases only.

Read more