How to Create Server And Database Using pgAdmin 4 || Postgresql Tips Tut...

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;