Ubuntu/postgres

From r00tedvw.com wiki
Jump to: navigation, search

Contents

Login as root

~$ sudo su - postgres
~$ psql
postgres=#

List databases

List all DBs

postgres=# \list -OR- \l

List all tables in current DB

postgres=# \dt 

Connect to DB

postgres=# \connect <database name>
Personal tools
Namespaces

Variants
Actions
Navigation
Mediawiki
Confluence
DevOps Tools
Ubuntu
Oracle Linux
AWS
Windows
OpenVPN
Grafana
Pivotal
osTicket
OTRS
phpBB
WordPress
VmWare ESXI 5.1
Crypto currencies
HTML
CSS
Python
Java Script
PHP
Raspberry Pi
Canvas LMS
Kaltura Media Server
MetaSploit
Zoneminder
Photoshop CS2
Fortinet
Uploaded
Certifications
General Info
Games
Meal Plans
NC Statutes
Toolbox