示例建库、建表语句

create database "test980500" with owner="root" encoding='utf-8';


\connect test980500

CREATE TABLE public.example_table (
    id integer NOT NULL,
    name character varying(100),
    timestamp_column timestamp,
    decimal_column numeric(5,2)
);

ALTER TABLE public.example_table OWNER TO root;


CREATE SEQUENCE public.example_table_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.example_table_id_seq OWNER TO root;

ALTER SEQUENCE public.example_table_id_seq OWNED BY public.example_table.id;

ALTER TABLE ONLY public.example_table ALTER COLUMN id SET DEFAULT nextval('public.example_table_id_seq'::regclass);

ALTER TABLE ONLY public.example_table  ADD CONSTRAINT example_table_pkey PRIMARY KEY (id);



INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (1, 'John', '2022-01-01 10:00:00', 12.34);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (2, 'Jane', '2022-02-02 12:34:56', 45.67);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (3, 'David', '2022-03-03 00:00:00', 78.90);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (4, 'Emily', '2022-04-04 15:30:00', 11.22);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (5, 'Michael', '2022-05-05 08:15:30', 33.44);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (6, 'Sarah', '2022-06-06 18:45:00', 55.66);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (7, 'Matthew', '2022-07-07 23:59:59', 77.88);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (8, 'Olivia', '2022-08-08 06:30:45', 99.00);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (9, 'Daniel', '2022-09-09 14:20:10', 12.34);
INSERT INTO public.example_table (id, name, timestamp_column, decimal_column) VALUES (10, 'Sophia', '2022-10-10 11:11:11', 45.67);