converted from sqlite3 to postgres