Tags » Postgresql

PostgreSQL basics

To login to prompt

#psql -h myhost -d mydb -U myuser -W

To create user

psql#CREATE USER anoop WITH password ‘tmppassword’;

To create database

 CREATE DATABASE db1 WITH OWNER anoop; 15 more words


PHP application in SAP Cloud Platform. With PostgreSQL, Redis and Cloud Foundry

Keeping on with my study of SAP’s cloud platform (SCP) and Cloud Foundry today I’m going to build a simple PHP application. This application serves a simple Bootstrap landing page. 1,639 more words


Golang: Database migration to manage your database schema by creating incremental SQL

In this post I write down my experience regarding  database migration configuration for Golang using Goose database migration.

Goose installation

$ go get -u github.com/pressly/goose/cmd/goose… 155 more words