Pgsql
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