akde/infosec

Information security is ultimately about managing risk

Postgres

Get version:

select version();

Get current user:

select current_user;

Get all databases:

select datname from pg_database;

Get all tables from a database:

select table_name from $dbname.information_schema.tables where table_schema = 'public';

Get details about a table:

select column_name, data_type from $dbname.information_schema.columns where table_name = 'menu';

You must be logged in to post a comment.

Personal collection of some infosec stuff. Primary purpose of this site is to collect and organize for myself.

Note: Some content is not publicly visible due to copyright issues. Therefore, some links could be broken.

python -c 'import pty;pty.spawn("/bin/bash")';

python3 -c 'import pty;pty.spawn("/bin/bash")';