How to See Pgsql Database List in Ubuntu

  • 17-10-2022
  • 748
  • Postgres
  • Haresh Chauhan

Postgres database list how to show? in this post, we will see how the listing of Postgres available database. For listing the Postgres database we need to press some commands in our command prompt. So in this example tutorial first you need to connect your SSH using the credential. Open your SSH terminal using credentials and press the below-provided command. and see your SQL database list.

If you want to switch your root user to Postgres root user, use provided below command in your server terminal, by entering you will switch to the Postgres account on your server.

sudo -i -u postgres

In case, If you are using the PostgreSQL prompt, you can directly enter provided command to get it immediately.

psql

Exist from your PostgreSQL prompt or account by typing the command :

postgres=#\q

How To Connect PostgreSQL With Laravel Application

Accessing your Postgres prompt without switching accounts. 
sudo -u postgres psql

postgres=#\list press in your command prompt. You will see your database server list and all available database.

postgres=#\list

image

Postgres Database Export

Install PostgreSQL Ubuntu 20.04 With pgAdmin4

We always thanks to you for reading our blogs.

dharmesh-image

Dharmesh Chauhan

(Swapinfoway Founder)

Hello Sir, We are brothers origin from Gujarat India, Fullstack developers working together since 2016. We have lots of skills in web development in different technologies here I mention PHP, Laravel, Javascript, Vuejs, Ajax, API, Payment Gateway Integration, Database, HTML5, CSS3, and Server Administration. So you need our service Please Contact Us

haresh-image

Haresh Chauhan

(Co-Founder)
We Are Also Recommending You :