PSQL get all table names

Karan Goyal
Feb 8, 2023

--

From the psql command line interface,

First, choose your database

\c database_name

Then, this shows all tables in the current schema:

\dt

--

--

Karan Goyal
Karan Goyal

Written by Karan Goyal

Full Stack Developer, Top Rated on Upwork, Worked on 90+ jobs in past 9 months and all jobs are rated 5 stars, coding is fun, and always looking forward to code

No responses yet