Difference between revisions of "PostgreSQL"

From Dogtag
Jump to: navigation, search
m (Connecting to Database)
m (Listing Tables)
Line 15: Line 15:
 
<pre>
 
<pre>
 
psql> \dt
 
psql> \dt
 +
</pre>
 +
 +
= Describing a Table =
 +
 +
<pre>
 +
psql> \d <name>
 
</pre>
 
</pre>
  

Revision as of 19:48, 7 November 2019

Installation

$ dnf install postgresql

Connecting to Database

$ psql postgres://<username>:<password>@<hostname>:<port>/<database>

Listing Tables

psql> \dt

Describing a Table

psql> \d <name>

See Also