• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

arunpjohny

Member since 09/03/2007

Name: Arun P Johny

Location: Bangalore, India

21 snippets

View their favorites

Their Tags

PROfile

All time reputation: 47

Achievement

arunpjohny's Recent Snippets Tagged 'postgres'

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. Convert OID to Bytea

   SQL postgres
   posted on January 16, 2012 by arunpjohny

2. Postgres: Schema resotre

   SQL postgres
   posted on August 26, 2011 by arunpjohny

3. Postgres Schema Backup

   SQL postgres
   posted on August 26, 2011 by arunpjohny

4. Postgres: alter default

   SQL postgres
   posted on July 6, 2011 by arunpjohny

5. Postgres: alter not null constraint

   SQL postgres
   posted on July 6, 2011 by arunpjohny

6. Scheduling automatic backup of postgres database in windows

   DOS Batch postgres
   posted on May 24, 2011 by arunpjohny

7. Postgres: How to read oid value using JDBC API

   Java postgres
   posted on May 21, 2011 by arunpjohny

8. Postgres: How to insert oid value using JDBC API

   Java postgres
   posted on May 21, 2011 by arunpjohny

9. Restore postgres backup file(dumpall)

   SQL postgres
   posted on November 19, 2007 by arunpjohny

10. Posgres backups in linux

    SQL postgres
    posted on November 19, 2007 by arunpjohny

11. Add a interval to a given date in postgresql

    SQL postgres
    posted on October 19, 2007 by arunpjohny

12. Get name of the weekday of a date in Postgresql

    SQL postgres
    posted on October 16, 2007 by arunpjohny

13. Function to get year from a date in Postgresql

    SQL postgres
    posted on October 16, 2007 by arunpjohny

14. Difference between two dates in Postgresql

    SQL postgres saved by 1 person
    posted on October 16, 2007 by arunpjohny

15. Postgresql : Alter the datatype of a column

    SQL postgres saved by 1 person
    posted on September 26, 2007 by arunpjohny

16. datediff function in postgresql

    SQL postgres saved by 2 people
    posted on September 7, 2007 by arunpjohny

17. Install plpgsql in a database

    SQL postgres saved by 1 person
    posted on September 6, 2007 by arunpjohny

18. Type Cast

    SQL postgres
    posted on September 5, 2007 by arunpjohny

19. Date Add/Substract

    SQL postgres
    posted on September 5, 2007 by arunpjohny

20. Date Parts

    SQL postgres
    posted on September 5, 2007 by arunpjohny

21. Checking for null in Postgresql

    SQL postgres
    posted on September 5, 2007 by arunpjohny