sample_postgres.sql

-- Table: public.persons
CREATE TABLE public.persons
(
    personid integer,
    lastname character varying(255) COLLATE pg_catalog."default",
    firstname character varying(255) COLLATE pg_catalog."default",
    address character varying(255) COLLATE pg_catalog."default",
    city character varying(255) COLLATE pg_catalog."default"
)
WITH (
    OIDS = FALSE
)

-- Insert some data
INSERT INTO public.persons(
	personid, lastname, firstname, address, city)
	VALUES (1, 'Smith', 'Bob', '123 test street', 'Any Town');