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

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';

(
id integer NOT NULL,
CONSTRAINT test_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

OWNER to postgres;

IS 'For demo';

insert into test values (1);

select * from test;

[KnowledgeChannel]

*Please help me get that beautiful YouTube Silver button. Do subscribe to the channel if my video was helpful.* ❤

[codermuyi]

This cleared up all the confusions I previously had about pgAdmin.

[GmanGavin]

You skipped the entire CREATE part from the title. This is just a video on using postgreSQL from pgAdmin

[victorudochukwu]

Thanks for this video, helped me to resolve my issue

[Harsh-ghrx]

so is that for local host or can be used anywhere?

[kenadams]

@Knowledge360Channel Please, consider making black screen.

[iam_shadow__]

Hi, I am facing a problem connection timwd out how to fix it

[aswinkumar]

In server nothing is there what to do
Do I need to install any server?

[TheAlirezak]

Is it possible to install pgadmin and postgre on /D: i DO NOT KNOW WHY it doesnt work !

[tamisunshine]

Mine doesn't have the explain tab in the end

[snehalsingh]

I'm setting the password as root still getting the error FATAL: password authentication failed. Can you let me know any solution?

[idulsacalvenjohn]

how can I fix it it says file name doest not exist?

[donovanraymond]

No option using Pgadmin4 to CREATE SERVER. Only CREATE SERVER GROUP or REGISTER SERVER.

[shubhampatil]

It's not working at my end I have followed the same process but still showing the error as
" Unable to connect to server" Is there any solution???