Connect to postgresql/pg database sql file in postgres with pgadmin how to connect postgress server in pgadmin

The solution for “Connect to postgresql/pg database sql file in postgres with pgadmin how to connect postgress server in pgadmin” can be found here. The following code will assist you in solving the problem.

#psql -h  -p  -d  -U 
psql -h localhost -p 5432 -d -U 1. Open/select the database in PgAdmin4
2. In the top menu, Click Tools, Query Tool
3. Click the left most icon in Query Tool and drill down to find the .sql file
you want.
4. Click Select
5. To run, Click the lightning icon (to the right of “No Limit”).

//CHECK POSTGRES IS WORKING OR NOT
sudo systemctl status postgresql

//THIS WILL ACCEPT PORTS
sudo pg_isready
sudo su postgres

//NAVIGATE TO SQL TERMINAL / BASH
psql

//CREATE A NEW USER WITH PASSWORD
CREATE USER shayon WITH PASSWORD ‘shayon’;

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

0
inline scripts encapsulated in