My Postgresql snippets

Install psql To get the psql, I simply installed the postgresapp for OSX which bundles the psql . We can start the psql from its GUI, or added its bin to our PATH. The specific path is: /Applications/Postgres.app/Contents/Versions/latest/bin You can also get psql by installing postgresql one click installer. Connect to DB with psql psql -h DbUrl -p…

install ora2pg on mac osx

Recently we need to migrate our on prem oracle database into postgresql on aws RDS. Looks like ora2pg is a nice little tool to mitigate the problem though not perfect. I am running OS X 10.10.5 Yosemite. It already comes with perl v5.18.2 as well as cpan for installing packages. download/install Oracle client The official document…