Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.
password as root
-- Database: MyDatabase
-- DROP DATABASE IF EXISTS "MyDatabase";
CREATE DATABASE "MyDatabase"
WITH
OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'English_United States.1252'
LC_CTYPE = 'English_United States.1252'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;
COMMENT ON DATABASE "MyDatabase"
IS 'This Database is for demo';
-- Table: public.test
-- DROP TABLE IF EXISTS public.test;
CREATE TABLE IF NOT EXISTS public.test
(
id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (id)
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.test
OWNER to postgres;
COMMENT ON TABLE public.test
IS 'For demo';
insert into test values (1);
select * from test;
