create_tables.sql

CREATE EXTENSION citext;

CREATE TABLE public.ethtxs
(
    time integer,
    txfrom citext,
    txto citext,
    gas bigint,
    gasprice bigint,
    block integer,
    txhash citext,
    value numeric,
    contract_to citext,
    contract_value citext,
);

CREATE VIEW max_block as
    SELECT
        MAX(block),
        '2.4.1' as version
    FROM public.ethtxs;