From the docs: *INTEGER*. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
So perhaps you should have said " SQLite integers are all up to 64 bit." Gerry On Tue, May 1, 2018 at 8:56 AM, Paul Sanderson <sandersonforens...@gmail.com > wrote: > SQLite integers are all 64 bit - I don't about postgress, so unless > postgress allows integers bigger than 64 bit, and you use them, you should > be OK with your table definitions above. > > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite- > Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > > On 1 May 2018 at 16:29, dmp <da...@dandymadeproductions.com> wrote: > > > Hello, > > > > Given a conversion from a database table that contains BigInt, long, > > field from PostgreSQL to a SQLite similar table. > > > > CREATE TABLE postgresqltypes ( > > data_type_id serial, > > bigInt_type bigint) > > > > CREATE TABLE sqlitetypes ( > > data_type_id INTEGER PRIMARY KEY AUTOINCREMENT, > > int_type INTEGER) > > > > How to store, for values outside range for Integer, > > String or Real? > > > > danap. > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users