postgrest-docs
postgrest-docs copied to clipboard
Renaming columns not working when new name is longer than 63 bytes (postgres column name length)
Hello! I found strange behavior:
I name my tables and columns in non-ASCII symbols (and it works, very convenient, "trust me, I am an engineer") And sometimes length of column is more than 63 bytes - for example, "УчитыватьИсправлениеИсходногоДокумента" (cyrillic). In database it stores as "УчитыватьИсправлениеИсходногоДо"
and when I request for table that stores it column, it will come out from the Postgrest as:
"УчитыватьИсправлениеИсходногоДо": "blablal...."
Ok, I'm trying to rename the column at query with ":": ...select=УчитыватьИсправлениеИсходногоДокумента:УчитыватьИсправлениеИсходногоДо
But it didn't work, in the output it stills goes as 'УчитыватьИсправлениеИсходногоДо'.
What can be a source of problem?
Sorry, wrong repo, will copy to the source repo with SQL example and delete this later
Duplicate of https://github.com/PostgREST/postgrest-docs/issues/471