stack_overflow

CREATE TABLE pcdagro
(
datahora TIMESTAMP WITHOUT TIME zone NOT NULL,
bateria DOUBLE PRECISION,
corrpsol DOUBLE PRECISION,
dirvelventomax DOUBLE PRECISION,
dirvento DOUBLE PRECISION,
fluxcalsolo DOUBLE PRECISION,
pluvio DOUBLE PRECISION,
pressaoatm DOUBLE PRECISION,
radsolacum DOUBLE PRECISION,
radsolliq DOUBLE PRECISION,
tempar DOUBLE PRECISION,
tempmax DOUBLE PRECISION,
tempmin DOUBLE PRECISION,
tempsolo100 DOUBLE PRECISION,
tempsolo500 DOUBLE PRECISION,
umidint DOUBLE PRECISION,
umidrel DOUBLE PRECISION,
velvento10m DOUBLE PRECISION,
velventomax DOUBLE PRECISION,
--...
)

CREATE TABLE pcdmet
(
datahora TIMESTAMP WITHOUT TIME zone NOT NULL,
dirvento DOUBLE PRECISION,
precipitacao DOUBLE PRECISION,
pressaoatm DOUBLE PRECISION,
radsolacum DOUBLE PRECISION,
tempar DOUBLE PRECISION,
umidrel DOUBLE PRECISION,
velvento DOUBLE PRECISION,
-- ...
)

CREATE TABLE pcdhidro
(
datahora TIMESTAMP WITHOUT TIME zone NOT NULL,
bateria DOUBLE PRECISION,
codifeixo DOUBLE PRECISION,
corrpsol DOUBLE PRECISION,
lgccsol DOUBLE PRECISION,
lgctsol DOUBLE PRECISION,
nivregua DOUBLE PRECISION,
pluvio DOUBLE PRECISION,
spressao DOUBLE PRECISION,
-- ...
)

CREATE TABLE pcdqagua
(
datahora TIMESTAMP WITHOUT TIME zone NOT NULL,
bateria DOUBLE PRECISION,
condut DOUBLE PRECISION,
corrpsol DOUBLE PRECISION,
od DOUBLE PRECISION,
ph DOUBLE PRECISION,
pluvio DOUBLE PRECISION,
profsonda DOUBLE PRECISION,
salinidade DOUBLE PRECISION,
solidostot DOUBLE PRECISION,
spressao DOUBLE PRECISION,
tempagua DOUBLE PRECISION,
turbidez DOUBLE PRECISION,
umidint DOUBLE PRECISION,
--..
)