Skip to content

Instantly share code, notes, and snippets.

@ssinganamalla
ssinganamalla / renamedb.sql
Created August 27, 2015 01:39
rename database name in postgres
//delete the user sessions
SELECT pg_terminate_backend( pid )
FROM pg_stat_activity
WHERE pid <> pg_backend_pid( )
AND datname = 'oldname';
ALTER DATABASE oldname RENAME TO newname
@ssinganamalla
ssinganamalla / LoadProperties.java
Created January 12, 2016 23:15
Load config properties file located in resources directory
public static ApplicationProperties loadProperties() {
Properties prop = new Properties();
InputStream input = null;
try {
ClassLoader classloader = Thread.currentThread().getContextClassLoader();
input = classloader.getResourceAsStream("config.properties");
// load a properties file
prop.load(input);