From the psql
command line interface,
First, choose your database
\c database_name
Then, this shows all tables in the current schema:
\dt
Programmatically (or from the psql
interface too, of course):
SELECT * FROM pg_catalog.pg_tables;
The system tables live in the pg_catalog
database.
Related Contents:
- How to switch databases in psql?
- What’s the PostgreSQL datatype equivalent to MySQL AUTO INCREMENT?
- What is the format for the PostgreSQL connection string / URL?
- Restore a postgres backup file using the command line?
- Copy a table from one database to another in Postgres
- How to get min/max of two integers in Postgres/SQL?
- input file appears to be a text format dump. Please use psql
- How to list indexes created for table in postgres
- Add timestamp column with default NOW() for new rows only
- pgadmin4 : postgresql application server could not be contacted.
- How do I get the current timezone name in Postgres 9.3?
- Postgres ENUM data type or CHECK CONSTRAINT?
- How to fix “ERROR: column c.relhasoids does not exist” in Postgres?
- fe_sendauth: no password supplied
- Select hardcoded values without table
- How to Disconnect from a database and go back to the default database in PostgreSQL?
- How to drop constraint by name in PostgreSQL?
- What does :: do in PostgreSQL? [duplicate]
- Dynamic (Column Based) Interval
- How do you change the character encoding of a postgres database?
- How do I upgrade postgresl database? Incompatibility error
- Is PostgreSQL suited to one OS? Is it better on Linux than Windows?
- Stop PostgreSQL from starting on Windows?
- A faster way to copy a postgresql database (or the best way)
- Options to retrieve the current (on a moment of running query) sequence value
- PostgreSQL 9.1 pg_restore error regarding PLPGSQL
- PostgreSQL 9.2 – Convert TEXT json string to type json/hstore
- Copy a few of the columns of a csv file into a table
- Updating integer column with null values in postgres
- Postgresql: How to find pg_hba.conf file using Mac OS X
- Can’t connect to Postgresql on port 5432
- Postgresql Truncation speed
- How to calculate DATE Difference in PostgreSQL?
- PostgreSQL JOIN data from 3 tables
- Postgresql change column type from int to UUID
- Postgres SELECT … FOR UPDATE in functions
- Multiple databases in docker and docker-compose
- data directory was initialized by PostgreSQL version 13, which is not compatible with this version 14.0
- How to use a PostgreSQL container with existing data?
- How can I solve Postgresql SCRAM authentication problem?
- PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
- currval has not yet been defined this session, how to get multi-session sequences?
- How to Drop User from Postgres Database [duplicate]
- Create a Superuser in postgres
- uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
- The forgotten assignment operator “=” and the commonplace “:=”
- SELECT or INSERT a row in one command
- Sequences not affected by transactions?
- Grant access to views in postgresql
- How to make my postgresql database use a case insensitive collation?