Difference between revisions of "PostgreSQL"
(→pg_dump) |
|||
| Line 4: | Line 4: | ||
<pre> | <pre> | ||
psql -h <HOST> -U <USERNAME> -w -d <DBNAME> | psql -h <HOST> -U <USERNAME> -w -d <DBNAME> | ||
| − | psql -h | + | psql -h localhost -U elugy -d elugy_portal |
</pre> | </pre> | ||
=== Parancs futtatása: === | === Parancs futtatása: === | ||
<pre> | <pre> | ||
| − | psql -h | + | psql -h localhost -U elugy -d elugy_portal -c "select count(1) from parameter;" |
</pre> | </pre> | ||
| Line 15: | Line 15: | ||
<pre> | <pre> | ||
| − | psql -h | + | psql -h localhost -U elugy -W -d elugy_portal -f test.sql |
| − | psql -h | + | psql -h localhost -U elugy -W -d elugy_portal < test.sql |
</pre> | </pre> | ||
| Line 27: | Line 27: | ||
<pre> | <pre> | ||
| − | pg_dump -b -d elugy_portal -h | + | pg_dump -b -d elugy_portal -h localhost -U elugy -W > elugy.sql |
| − | pg_dump --blobs --dbname elugy_portal --host | + | pg_dump --blobs --dbname elugy_portal --host localhost --username elugy --password > elugy.sql |
</pre> | </pre> | ||
| Line 34: | Line 34: | ||
<pre> | <pre> | ||
| − | createdb -h | + | createdb -h localhost -U elugy -W -O elugy testdb |
| − | createdb --host | + | createdb --host localhost --username elugy --password --owner elugy testdb |
</pre> | </pre> | ||
Revision as of 14:24, 29 October 2018
Contents
psql
Csatlakozás:
psql -h <HOST> -U <USERNAME> -w -d <DBNAME> psql -h localhost -U elugy -d elugy_portal
Parancs futtatása:
psql -h localhost -U elugy -d elugy_portal -c "select count(1) from parameter;"
SQL fájl futtatása, dump betöltés:
psql -h localhost -U elugy -W -d elugy_portal -f test.sql psql -h localhost -U elugy -W -d elugy_portal < test.sql
Csatlakozás utáni parancsok:
\lvagy\list: adatbázisok listázása\qvagy\quit: kilépés
pg_dump
pg_dump -b -d elugy_portal -h localhost -U elugy -W > elugy.sql pg_dump --blobs --dbname elugy_portal --host localhost --username elugy --password > elugy.sql
createdb
createdb -h localhost -U elugy -W -O elugy testdb createdb --host localhost --username elugy --password --owner elugy testdb
Vagy PSQL paranccsal való csatlakozás után a konzolon:
create database testdb owner elugy;
