user6918: 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.

user5926: 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.

6918: <p>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:</p>
<ul>
<li>hash32type</li>
<li>lovelace</li>
<li>word64type</li>
</ul>
<p>Can anyone point me to a resource that would provide me the required knowledge for converting these types into C# types?
Thank you.</p>
 5926: <p>SQL domain types like <code>lovelace</code> etc are created in the stage one migration scripts (<code>schema/migration-1*</code> of the repo). Eg <code>lovelace</code> is:</p>
<pre><code>CREATE DOMAIN lovelace AS numeric (20, 0) CHECK (VALUE &gt;= 0 AND VALUE &lt;= 18446744073709551615);
</code></pre>
<p>From these domain types you should be able to figure out the appropriate language type for your language.</p>
