User Tools

Site Tools


databaze

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
databaze [2018/04/01 13:36]
ww
databaze [2022/03/16 09:38] (current)
Line 18: Line 18:
 <code postgresql>\l</code> <code postgresql>\l</code>
      
-Vvýběr databáze+Výběr databáze
 <code postgresql>\connect dbname</code> <code postgresql>\connect dbname</code>
      
Line 26: Line 26:
 Výpis uživatelů Výpis uživatelů
 <code postgresql>\du</code> <code postgresql>\du</code>
 +
 +==== Migrace mezi verzemi ====
 +https://www.kostolansky.sk/posts/upgrading-to-postgresql-12/
  
 ---- ----
Line 36: Line 39:
 GRANT ALL ON dbname.* TO username@localhost IDENTIFIED BY 'somepass'; GRANT ALL ON dbname.* TO username@localhost IDENTIFIED BY 'somepass';
 </code> </code>
 +
 +Seznam databází
 +<code mysql>SHOW DATABASES;</code>
 +
 +----
 +
 +===== SQLite =====
 +
 +==== Výpis tabulek ====
 +
 +<code>.tables</code>
databaze.1522582606.txt.gz · Last modified: 2022/03/16 09:38 (external edit)