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)

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 ?.

Please Like, Comment, and Subscribe to my channel. ❤

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;