SQL Learning Path - Creating and Dropping Databases Discussion
Discussion for
SQL Learning Path - Creating and Dropping Databases
Initially, I got a connection error, to the effect, 'database 'my_user_name' does not exist.
After running createdb and then psql, everything works and I was able to connect using 'TablePlus' : )
This a good one that I run every so often to check for any old databases laying around that I can get rid of, so good call on mentioning it!
I had the same connection error that Eric Halverson mentioned and my simple fix was to enter postgres as the database name in the pop up window of tableplus when creating the connection. For the reason as to why that happens, I found this comment on reddit that explains it pretty well => https://www.reddit.com/r/PostgreSQL/comments/s0f6f3/comment/hs1hwwp/?utm_source=share&utm_medium=web2x&context=3