Tags » PostgreSQL

Drop all Schemas in Postgres

This is function which would drop all the schemas in a Postgres database.

CREATE OR REPLACE FUNCTION drop_all () 
   RETURNS VOID  AS
   $$
   DECLARE rec RECORD; 
   BEGIN
       -- Get all the schemas
        FOR rec IN
        select distinct schemaname
         from pg_catalog.pg_tables
         -- You can exclude the schema which you don't want to drop by adding another condition here
         where schemaname not like 'pg_catalog'  
           LOOP
             EXECUTE 'DROP SCHEMA ' || rec.schemaname || ' CASCADE'; 
           END LOOP; 
           RETURN; 
   END;
   $$ LANGUAGE plpgsql;
 
select drop_all();
Sumit Chawla

[GSOC 2014] Week 7-8-9 Status

Hi guys!!!

These three previous week, I have been coding Json API(GET, POST, PUT, DELETE) requests.

Besides, I have found a solution to support a generic store service in Hibernate according chosen database(MySQL, PostgreSQL, …). 233 more words

Dhis2

Upgrading PostgreSQL from 9.4 beta1 to 9.4 beta2

MacPorts installs PostgreSQL 9.4 beta2 in the same directory as PostgreSQL 9.4 beta 1 was in. And going from beta 1 to beta 2 requires an upgrade for the cluster to work. 320 more words

Deploying Versions with Zero Downtime

Two months, almost to the day since we last hit problems with deployment, it looks like we are here again. Up till the day before, deployments worked fine if a little slow, but now they fail with a timeout. 439 more words

AWS

Get "tone" from corporate disclosures: PostgreSQL, Python, and R.

The paper by Loughran and McDonald (2011) develops lists of words that are intended to reflect “tone” in financial text. The following code retrieves these lists and applies them to a large body of text (over a billion words) from 250,000+ conference calls. 1,002 more words

Brewing a potion with Bluemix, PostgreSQL, Node.js in the cloud

Here is a heady potion made with the key ingredients of IBM’s Bluemix, PostgreSQL & Node.js. In this post I instantiate an app ‘mypgdb01′ on IBM’s Bluemix which uses the services of PostgreSQL in the cloud. 788 more words

Cloud Computing

Frightening Facts about MySQL

So you might’ve seen Destroy all Software’s talk about JavaScript:

Here’s a similar talk (less funny more scary) about MySQL:

Sql