Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
db:postgresql [2022/01/26 11:37] 127.0.0.1 external edit |
db:postgresql [2026/04/02 11:37] (current) tomas [Příkazová řádla] |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ======PgSQL (Postgre SQL)====== | ======PgSQL (Postgre SQL)====== | ||
| - | ====Obsah==== | + | ==== Odkazy |
| - | < | + | |
| - | Externi odkazy\\ | + | |
| - | Start/ | ||
| - | Uzivatele/ | ||
| - | Prava\\ | ||
| - | Tabulky\\ | ||
| - | Data v tabulkach\\ | ||
| - | Vnitrni funkce psql\\ | ||
| - | zaloha / obnoveni zalohy databaze\\ | ||
| + | [[http:// | ||
| - | ===Externi odkazy=== | ||
| + | ==== Příkazová řádla ==== | ||
| - | [[http://www.linuxsoft.cz/ | + | ===zaloha |
| + | pg_dump dbname > outfile\\ | ||
| + | pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\ | ||
| + | psql dbname > infile\\ | ||
| + | pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\ | ||
| + | psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\ | ||
| - | ====Start/stop/status==== | + | === klient |
| + | %%psql -U uživatel postgre://server: | ||
| - | ====Uzivatele/ | + | ==== Postgre SQL příkazy a SQL jazyk ==== |
| + | === Uzivatele/ | ||
| SYSID skupina USER uzivatel1, uzivatel 2 ... bytvori skupinu skupina s uzivateli uzivatel1, uzivatel2\\ | SYSID skupina USER uzivatel1, uzivatel 2 ... bytvori skupinu skupina s uzivateli uzivatel1, uzivatel2\\ | ||
| ALTER GROUP skupina ADD USER uzivatel3 , uzivatel4 ... prida uzivatele uzivatel3, uzivatel4\\ | ALTER GROUP skupina ADD USER uzivatel3 , uzivatel4 ... prida uzivatele uzivatel3, uzivatel4\\ | ||
| Line 64: | Line 62: | ||
| ===Vnitrni funkce psql=== | ===Vnitrni funkce psql=== | ||
| - | |||
| - | |||
| timeofday(); | timeofday(); | ||
| - | |||
| - | |||
| - | ===zaloha / obnoveni zalohy databaze=== | ||
| - | pg_dump dbname > outfile\\ | ||
| - | pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\ | ||
| - | |||
| - | psql dbname > infile\\ | ||
| - | pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\ | ||
| - | psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\ | ||
| ====SQL==== | ====SQL==== | ||
Last modified: 2022/01/26 11:37
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3