How To Show Tables In PostgreSQL Database Using SQL Shell psql And pgAdmin || PostgreSQL Tutorials

#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/
WhatsApp - https://wa.me/+919090484904
LinkedIn - https://www.linkedin.com/in/akram-sohail-499489131/
Skype - https://join.skype.com/invite/snliyulHrEBb
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++
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows

Description
------------------

How To Show Tables In PostgreSQL Database Using SQL Shell psql And pgAdmin || PostgreSQL Tutorials

Syntax
-------
SELECT * FROM pg_catalog.pg_tables
WHERE schemaname = 'schema name'
AND schemaname != 'information_schema' ;

Query
-------
SELECT * FROM pg_catalog.pg_tables
WHERE schemaname = 'public'
AND schemaname != 'information_schema' ;


Syntax
-------
select * from information_schema.tables
where table_schema='schema name'
and table_type = 'BASE TABLE OR VIEW';


Query
-------
--Will display all tables
select * from information_schema.tables
where table_schema='public'
and table_type = 'BASE TABLE';

--Will display all views
select * from information_schema.tables
where table_schema='public'
and table_type = 'VIEW';

How To Show Tables In PostgreSQL Database Using SQL Shell psql And pgAdmin PostgreSQL Tutorials
PostgreSQL Tutorials
How To
Show Tables In PostgreSQL Database Using SQL Shell psql And pgAdmin
Show Tables In PostgreSQL Database
Show Tables In PostgreSQL Database Using SQL Shell psql
Show Tables In PostgreSQL Database Using pgAdmin
Show Tables In PostgreSQL Database
PostgreSQL Database Tables