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 😢.
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
No comments:
Post a Comment