Search for a command to run...
I am just getting back into PostgreSQL. Here are the things I had to learn today:
1. Command line usage:
2. Dumping data for import on another server
pg_dump -o mydb -U postgres -W > mydb.sql
-o has to do with oids (Not sure if I need this yet)
-U is for user
No comments yet. Be the first to comment.
After I upgraded to Windows 11, my Sublime Text right-click context menu disappeared. Putting this here for my future reference, and hope it helps the next person. Cheers! @echo off REM Add Sublime Text to Windows 11 Right-Click Context Menu REM Run ...
This post is short and sweet for now. I plan on adding more commands as I get more familiar with VIM. Today I wanted to search and replace text in a JSON file using VIM. Turns out it is rather easy. :%s/"login"/"username"/g In my situation I needed ...
This is a short and sweet post. I often will start a project by initializing my project with git locally: git init . I then went to GitHub and created the project there. I chose a license file since this was a public repository. That created the ini...
This morning, I struggled to get Guest Additions installed on my Ubuntu Server VBox, which I am going to use to prepare a codebase for migration to Linux. It has been a while since Digital Ocean droplets are inexpensive to fire up and use. Here are t...
Last 10 queries I had a situation where I wanted to check if some SQL changes I made were working properly. It involved a transaction with a bunch of queries. Yes I could verify the data but I wanted to visually see the queries that my scripts were g...