Re: change JSON serialization for BIGINT?

вт, 26 нояб. 2024 г. в 14:34, Tim McLaughlin <tim(at)gotab(dot)io>:

> Is there a way to have Postgres serialize BIGINT as a string rather than
> number in JSON? By default it does this:
>
>
> select row_to_json(row(500::bigint));
> row_to_json
> -------------
> {"f1":500}
>
> But I want it to do this (note that "500" is quoted):
>
> select row_to_json(row(500::bigint));
> row_to_json
> -------------
> {"f1":"500"}
>

Will this work?

select row_to_json(row(500::text));

--
Victor Yegorov