How to Create Server And Database Using pgAdmin 4 || Postgresql Tips Tutorials || Knowledge 360

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360. Here I post technical videos, mainly related to computer science and programming. I am posting project videos with coding explanations. I make tutorial videos on Technical Topics. Stay Connected, Stay Tuned, Study Smart.
– Knowledge 360 (Akram Sohail)

Follow me on Social Media
————————————————–
Facebook – https://www.facebook.com/sonu.babu.5872682/
Instagram – https://www.instagram.com/akkubakku007/
google+ – https://plus.google.com/u/0/116728183002228924227
Blog – https://knowledge360blog.blogspot.in/

Business/Mentorship/Projects – [email protected]
Source Codes –
Topics
———
Oracle
MySQL
PostgreSQL
SQL Server
PHP
C
C++
Python
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows
Miscellaneous

Description
——————

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;