Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Replace jsonb by text #1588

Closed
kderme opened this issue Jan 1, 2024 · 0 comments · Fixed by #1700
Closed

Replace jsonb by text #1588

kderme opened this issue Jan 1, 2024 · 0 comments · Fixed by #1700
Assignees
Labels
enhancement New feature or request

Comments

@kderme
Copy link
Contributor

kderme commented Jan 1, 2024

jsonb Postres type provides the ability to query keys of the json. However it's slower to insert. We could use text by default and document ways for users to migrate to json if they do such queries. A command like

alter table tx_metadata alter column json type jsonb USING json::jsonb;

could be used

@kderme kderme added bug Something isn't working enhancement New feature or request and removed bug Something isn't working labels Jan 1, 2024
@Cmdv Cmdv self-assigned this Jan 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
Status: Done
2 participants