Postgresql: Difference between revisions
Jump to navigation
Jump to search
(→exit) |
(→update) |
||
Line 20: | Line 20: | ||
=update= | =update= | ||
UPDATE users SET admin = 1 WHERE user_id = 14002; | UPDATE users SET admin = 1 WHERE user_id = 14002; | ||
=Create database= | |||
CREATE DATABASE dbname OWNER username; | |||
=Delete database= | |||
DROP DATABASE dbname; | |||
=Import a database= | |||
psql username -h hostname -d dbname < dump.sql | |||
=Create user= | |||
CREATE USER username WITH PASSWORD 'MYPASS'; |
Revision as of 09:11, 27 February 2020
psql
Connect to remote database:
export PGPASSWORD=password && psql --host=10.111.222.1 --port=5492 --username=user --no-password postgres
install psql
apt-get install freetds-bin
List databases
1
SELECT datname FROM pg_database;
2
\l
select database
\c testdb;
show tables
\dt
Change view. One line per attribute
\x on
exit
\q
update
UPDATE users SET admin = 1 WHERE user_id = 14002;
Create database
CREATE DATABASE dbname OWNER username;
Delete database
DROP DATABASE dbname;
Import a database
psql username -h hostname -d dbname < dump.sql
Create user
CREATE USER username WITH PASSWORD 'MYPASS';