Pgsql

Iš Žinynas.
Jump to navigation Jump to search

Connect to database:

\c database_name

Show tables

\dt

Select:

SELECT * FROM users;

Delete:

DELETE FROM lentele WHERE stulpelis = 1;

Remote login

psql -h ip.ad.res -p 5432 -U user -d database