libpq send integer as binary

Question

I have a libpq program that is routinely inserting numbers into a database. These numbers, which I'm expecting to grow quite large, are stored int the uint64_t type. I'm wanting to send the integer to libpq as binary, but Postgres won't be able to tell its unsigned. Is there a way to specify an unsigned integer in Postgres or libpq?

When you say you're expecting them to grow "quite large" - genuinely over (2^63)-1? — Jon Skeet
– Jon Skeet, Commented Aug 19, 2009 at 15:13

user80168 · Accepted Answer · 2009-08-19 15:26:26Z

1

There are no unsigned datatypes in PostgreSQL.

If you really are going over 9223372036854775808, then you should use NUMERIC data type.

answered Aug 19, 2009 at 15:26

user80168

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

libpq send integer as binary

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related