When we come across scenarios whereby we have to drop all the tables in a database before a restore, the following commands come in handy. DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public; To manually drop all tables in a database we select 'DROP TABLE "' || tablename || '" cascade;' from pg_tables; To check if a table exist and then to drop it if it does select 'DROP TABLE IF EXISTS "' || tablename || '" cascade;' from pg_tables;

Homebrew installs java at /usr/local/Cellar/openjdk/. There may be a requirement where you may need to run multiple version of java on the same MacOS. It involves few steps that we need to follow to setup and configure the needed version on our machines. (more…)

To remove the message "the default interactive shell is now zsh", edit the .bash_profile (more…)

i) Add an upstream to the remote github URL $ git remote add upstream <GIT_REPO_URL> ii) Retrieve all branches from upstream $ git fetch upstream iii) Merge the repo to your local branch $ git merge upstream/master iv) Now, push the changes to your remote forked repository $ git push origin master

Once AWS SAM CLI is installed/setup in your system, you will need to give a reference to sam.cmd file. In windows, you can give an alias to the folder where SAM is setup alias sam="/c/Program\ Files/Amazon/AWSSAMCLI/bin/sam.cmd" In linux, $ vi ~/.bashrc alias = sam="sam.cmd" $ source ~/.bashrc

  There are scenarios when you are contributing to a subset of a very large project. Instead of downloading the entire project, you may want to bring down a copy of ONLY the needed folders or files (to save download time, space ...) Git allows partial cloning which allows Git to function without having a complete copy of the repository. Follow the below steps to try out Git's sparse-checkout feature. (more…)