-
Notifications
You must be signed in to change notification settings - Fork 61
Data type STRING not recognized #15
Copy link
Copy link
Open
Description
Hi,
I'm experimenting with postgresql-parser to intercept and rewrite some queries to a postgresql database.
One problem I have encountered is that the formatter will output "STRING" by default for string data type. PostgreSQL does not support this, instead the data type name is "TEXT". CockroachDB supports "TEXT" as an alias for "STRING" [1]
In order to make query-rewriting work, I've patched postgresql-parser to output "TEXT" data type by default instead of "STRING". I think this could be a reasonable default since CockroachDB supports both.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels