[BUG]In PostgreSQL, int8 represents the 64-bit integer type, not tinyint

[fuzi1996]

Fully reproducible code snippet

import sqlglot

if __name__ == '__main__':
    sql = """create table a_table
        (
            column_id      int8 not null constraint a_table_pk primary key,
            column_2       date,
            column_3       varchar(2000),
            column_4       int2,
            column_5       int4
        );
    """
    expressions = sqlglot.parse(sql, dialect="postgres")
    expression = expressions[0]
    print(expression.sql())

output

CREATE TABLE a_table (column_id **TINYINT** NOT NULL CONSTRAINT a_table_pk PRIMARY KEY, column_2 DATE, column_3 VARCHAR(2000), column_4 SMALLINT, column_5 INT)

"int8" being mistranslated as "tinyint"

Official Documentation

postgresql 10 official document: https://www.postgresql.org/docs/10/datatype.html#DATATYPE-TABLE