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
