Skip to content

Instantly share code, notes, and snippets.

@dincosman
Created May 14, 2024 17:01
Show Gist options
  • Select an option

  • Save dincosman/9037e3dd89fcdec9015055910e8e3ef9 to your computer and use it in GitHub Desktop.

Select an option

Save dincosman/9037e3dd89fcdec9015055910e8e3ef9 to your computer and use it in GitHub Desktop.
Check the inserted records in PostgreSQL database psql command line
[postgres@ferret01 data]$ psql -d ferretdb
psql (16.2)
Type "help" for help.
-- For a mongodb database - a schema created in postgresql
-- For a mongodb collection - a relation/table created in postgresql
ferretdb=# SET schema 'test';
SET
ferretdb=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------------+-------+----------
test | _ferretdb_database_metadata | table | postgres
test | posts_4c2edfdc | table | postgres
(2 rows)
ferretdb=# select count(*) from posts_4c2edfdc;
count
---------
1000000
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment