Show tables in PostgreSQL

PostgreSQL

 

A well-known open-source database, developed by PostgreSQL Global Development Group. Skyvia requires the server to be available from Internet. Skyvia supports PostgreSQL, EnterpriseDB, Pervasive Postgres SQL servers, Heroku Postgres.

The view pg_tables provides access to useful information about each table in the database

Query Text

SELECT * 
FROM 
    pg_catalog.pg_tables
ORDER BY
    schemaname, tablename
    
  

Open Query