I'm working with postgres14 in a docker container on a remote Rocky Linux VM. After a little bit of pain I managed to access the database from outside the container, at which point I wanted to create a test database and some test tables to see if everything goes well. Unfortunately it doesn't, and here are the steps I'm going through.
connect to postgres
psql -U username -h container_ip
once I'm in, I want create the db
create database mydb
now I try to create a table
create table mytable
trying to check if it's created
Did not find any relations.
Now I checked this question as well as this one, but since I'm not really a DBA or anything of a sort I'm having a hard time understanding how to apply these answers to my particular problem. I tried altering search_path as suggested in one of the answers on these two links, in particular setting it to a public schema for mydb, but that didn't work.
Does anyone have an answer? Thank you very much!