Skip to content

Add docs for migrating existing tables #6

@mw44118

Description

@mw44118

I had a table with a text column named "secret_data" and I had to write a SQL migration like this:

sql="alter table blah alter column secret_data type bytea using private_key::bytea"

That took me a while to get right.

Also, that just changes the type -- it doesn't encrypt the data using the settings.SECRET_KEY. I'm still figuring out how to do this!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions