PostgreSQL
A PostgreSQL credential has been identified
[cmeeks@hetemit register_hetemit]$ psql --host=localhost --port=5432 --dbname=register_hetemit -U railsdev
Password for user railsdev: OpenProduceTreat153
psql (10.14)
Type "help" for help.
register_hetemit=> Connected
DBs
register_hetemit=> \list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
register_hetemit | railsdev | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)register_hetemit.users Table
register_hetemit=> \c register_hetemit
You are now connected to database "register_hetemit" as user "railsdev".
register_hetemit=> \d
List of relations
Schema | Name | Type | Owner
--------+-----------------------------------+----------+----------
public | active_storage_attachments | table | railsdev
public | active_storage_attachments_id_seq | sequence | railsdev
public | active_storage_blobs | table | railsdev
public | active_storage_blobs_id_seq | sequence | railsdev
public | ar_internal_metadata | table | railsdev
public | schema_migrations | table | railsdev
public | users | table | railsdev
public | users_id_seq | sequence | railsdev
(8 rows)
register_hetemit=> SELECT * FROM users;
id | email | username | password_digest | picture | created_at | updated_at | invite_code
----+-------+----------+-----------------+---------+------------+------------+-------------
(0 rows)Empty