PostgreSQL

Connection

$ su postgres
Password: 
$ psql
psql (9.4.15)
Type "help" for help.

Query

postgres=# \list
postgres=# \c database_name
pentesterlab=# \d
pentesterlab=# select * from users;

Readfile

$ psql -U photoblog -W photoblog
# CREATE TABLE demo(t text);
# COPY demo from '[FILENAME]';
# SELECT * FROM demo;

Last updated