postgresqlHow do I show tables in PostgreSQL?
To show tables in PostgreSQL, you can use the command \d
or \dt
in the psql command line.
Example code
\d
Output example
List of relations
Schema | Name | Type | Owner
--------+---------------------+-------+---------
public | customers | table | postgres
public | orders | table | postgres
public | products | table | postgres
(3 rows)
The command \d
will show all the tables, views, sequences, and foreign tables in the current database. The command \dt
will only show the tables.
Parts of the code:
\d
or\dt
: These are the commands used to show the tables in PostgreSQL.public
: This is the schema of the database.customers
,orders
,products
: These are the names of the tables.table
: This is the type of the object.postgres
: This is the owner of the table.
Helpful links
More of Postgresql
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can I use PostgreSQL's "zero if null" feature?
- How can I use PostgreSQL with YAML?
- How do I parse XML data using PostgreSQL?
- How can I use PostgreSQL XOR to compare two values?
- How do I export data from PostgreSQL to an XML file?
- How can I monitor PostgreSQL performance using Zabbix?
- How can I convert XML data to a PostgreSQL table?
- How do I install and configure PostgreSQL on a Windows machine?
- How do I store binary data in a Postgresql database using the bytea data type?
See more codes...