35 lines
1.1 KiB
MySQL
35 lines
1.1 KiB
MySQL
|
SELECT pg_catalog.set_config('search_path', '', false);
|
||
|
|
CREATE TABLE public."metric three" (
|
||
|
|
"timestamp" timestamp without time zone,
|
||
|
|
"tag four" text,
|
||
|
|
"string two" text
|
||
|
|
);
|
||
|
|
ALTER TABLE public."metric three" OWNER TO postgres;
|
||
|
|
CREATE TABLE public.metric_one (
|
||
|
|
"timestamp" timestamp without time zone,
|
||
|
|
tag_one text,
|
||
|
|
tag_two text,
|
||
|
|
int64_one integer,
|
||
|
|
int64_two integer,
|
||
|
|
bool_one boolean,
|
||
|
|
bool_two boolean,
|
||
|
|
uint64_one bigint,
|
||
|
|
float64_one double precision
|
||
|
|
);
|
||
|
|
ALTER TABLE public.metric_one OWNER TO postgres;
|
||
|
|
CREATE TABLE public.metric_two (
|
||
|
|
"timestamp" timestamp without time zone,
|
||
|
|
tag_three text,
|
||
|
|
string_one text
|
||
|
|
);
|
||
|
|
ALTER TABLE public.metric_two OWNER TO postgres;
|
||
|
|
COPY public."metric three" ("timestamp", "tag four", "string two") FROM stdin;
|
||
|
|
2021-05-17 22:04:45 tag4 string2
|
||
|
|
\.
|
||
|
|
COPY public.metric_one ("timestamp", tag_one, tag_two, int64_one, int64_two, bool_one, bool_two, uint64_one, float64_one) FROM stdin;
|
||
|
|
2021-05-17 22:04:45 tag1 tag2 1234 2345 t f 1000000000 3.1415
|
||
|
|
\.
|
||
|
|
COPY public.metric_two ("timestamp", tag_three, string_one) FROM stdin;
|
||
|
|
2021-05-17 22:04:45 tag3 string1
|
||
|
|
\.
|