Criar_bd.txt

CREATE TABLE IF NOT EXISTS public.dados
(
    endereco character varying(50) COLLATE pg_catalog."default" NOT NULL,
    datadia date,
    tempmax double precision,
    tempmin double precision,
    temperatura double precision,
    feelslikemax double precision,
    feelslikemin double precision,
    feelslike double precision,
    dew double precision,
    humidity double precision,
    precip double precision,
    precipprob double precision,
    precipcover double precision,
    snow double precision,
    snowdepth double precision,
    windgust double precision,
    windspeed double precision,
    winddir double precision,
    sealevelpressure double precision,
    cloudcover double precision,
    visibility double precision,
    solarradiation double precision,
    solarenergy double precision,
    uvindex integer,
    severerisk integer,
    sunrise time without time zone,
    sunset time without time zone,
    moonphase double precision,
    conditions character varying(20) COLLATE pg_catalog."default",
    description character varying(70) COLLATE pg_catalog."default",
    icon character varying(30) COLLATE pg_catalog."default"
)