Specifically, I am using the Npgsql lib in a C# console app, and am reading data just fine so far for the obvious types like bigint, uinteger, boolean, etc. - but for a few different types/columns in some tables I am unsure:

  • hash32type
  • lovelace
  • word64type

Can anyone point me to a resource that would provide me the required knowledge for converting these types into C# types? Thank you.

1 Answer 1


SQL domain types like lovelace etc are created in the stage one migration scripts (schema/migration-1* of the repo). Eg lovelace is:

CREATE DOMAIN lovelace AS numeric (20, 0) CHECK (VALUE >= 0 AND VALUE <= 18446744073709551615);

From these domain types you should be able to figure out the appropriate language type for your language.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.