Differences

This shows you the differences between two versions of the page.

--- wiki:ostatni:potgres:start [2019/12/16 15:35]
root vytvořeno
+++ wiki:ostatni:potgres:start [2019/12/16 15:35] (current)
root
@@ Line 1: / Line 1: @@
-\l	- list databases
+  * \l	- list databases
-\c	- connect to db
+  * \c	- connect to db
-\dn	- list schemas
+  * \dn	- list schemas
-\dt	- list tables
+  * \dt	- list tables
-\dtS	- list tables + system tables
+  * \dtS	- list tables + system tables
-\q	- quit
+  * \q	- quit
+  *
-postgres=# SHOW search_path;
+  * postgres=# SHOW search_path;
-postgres=# \dt
+  * postgres=# \dt
-postgres=# SET search_path TO api;
+  * postgres=# SET search_path TO api;
-postgres=# \dt
+  * postgres=# \dt
-postgres=# SET search_path TO "$user",public;
+  * postgres=# SET search_path TO "$user",public;

wiki.lkaplan.cz