Difference between revisions of "PostgreSQL"

From Dogtag
Jump to: navigation, search
(Created page with "= Installation = <pre> $ dnf install postgresql </pre> = Connecting to Database = <pre> $ psql postgres://<username>:<password>@<hostname>:<port>/<database> </pre> = See A...")
 
m (Connecting to Database)
Line 9: Line 9:
 
<pre>
 
<pre>
 
$ psql postgres://<username>:<password>@<hostname>:<port>/<database>
 
$ psql postgres://<username>:<password>@<hostname>:<port>/<database>
 +
</pre>
 +
 +
= Listing Tables =
 +
 +
<pre>
 +
psql> \dt
 
</pre>
 
</pre>
  

Revision as of 04:42, 7 November 2019

Installation

$ dnf install postgresql

Connecting to Database

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

Listing Tables

psql> \dt

See Also