/* Code Comments */9 posts tagged with "psql"
postgresql: user vs role
2022-11-28
|~2 min read
|290 words
I was working in Postgres recently and realized that I was confused about whether or not to use the or command. Heading to StackOverflow…
handling incompatible postgresql versions
2022-11-28
|~3 min read
|567 words
I tried to start a PostgreSQL database yesterday from the command line and I was greeted with the error: I’m not sure how, but it seems that…
group, count, and order a table in postgres
2022-11-28
|~4 min read
|627 words
I have a table that represents a many to one relationship. How, then, do I find out which of the “ones” have the most “manys”? Postgres has…
reminder: logging into postgres with shell commands
2022-11-28
|~3 min read
|595 words
PGAdmin, Dbeaver, etc. are useful GUIs for managing and reviewing Postgres databases. Sometimes, however, there’s a desire to login via the…
postgres interactive shell, start, stop, and docker
2022-11-28
|~1 min read
|170 words
Recently I was working with a Docker image of a Postgres database. Everything was going great. docker image At one point, I wanted to…
postgres return types in node - parse strings to whatever you want
2022-11-28
|~2 min read
|260 words
By default the returns everything from PostgreSQL as a string. Brian Carlson, the author of , provides a solution for fixing this with his…
json operators and functions in postgres
2022-11-28
|~2 min read
|378 words
I wrote in the past about Array Intersections in Postgres, which alluded to operators and functions available for arrays within Postgres…
postgres tuples only
2022-11-28
|~2 min read
|233 words
If you’re just learning how to use Postgres from the terminal (as I am), sometimes you click the wrong button and don’t know what it does…
inserting values into a table - postgres
2022-11-28
|~3 min read
|415 words
How do you insert multiple values? I always find myself looking this up. I decided I’d jot it down here for future reference. Hopefully it…