Get raw string representation

[NotBobTheBuilder]

I have a query which returns JSON, which I want to send back to a client in string form.

node-postgres parses my query result into an actual JavaScript object - which is useful in most cases - but here it seems wasteful to have to JSON.stringify what the library just JSON.parsed.

Is there a way to access the raw query result as a string (or perhaps change the query so it doesn’t get parsed at all), so I can just res.send the string?

Thanks!

[NotBobTheBuilder]

(For now I’ve just put pg.types.setTypeParser(114, function(x) { return x; }); after the pg import - is there a better way?

[sehrope]

If you cast the column to text in the query SQL then it'll be sent over the wire as is. Ex:

SELECT some_json::text FROM (SELECT '{"foo":"bar"}'::json AS some_json) t;

[jleppert]

+1. The big benefit here is to have all the JSON serialization already done for you, in this case the use case is proxying to a web client. What do people think of adding a config option to make this more explicit?

[brianc]

If you want json to be represented as text, @sehrope has the right approach!