Postgresql: Difference between revisions

From Halfface
Jump to navigation Jump to search
Line 28: Line 28:
=Create user=
=Create user=
  CREATE USER username WITH PASSWORD 'MYPASS';
  CREATE USER username WITH PASSWORD 'MYPASS';
=Set super privileges=
ALTER USER username WITH SUPERUSER;
=List users=
\du
=Deleting user=
DROP USER nomusr
=Getting help=
\? or \h
=Exit from Postgres console=
\q

Revision as of 09:13, 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';

Set super privileges

ALTER USER username WITH SUPERUSER;

List users

\du

Deleting user

DROP USER nomusr

Getting help

\? or \h

Exit from Postgres console

\q