00krishna

import psycopg2 as pg
import pandas.io.sql as psql
 
# get connected to the database
connection = pg.connect("dbname=mydatabase user=postgres")
 
dataframe = psql.frame_query("SELECT * FROM <tablename>", connection)

00krishna

# -*- coding: utf-8 -*-
"""
LICENSE: BSD (same as pandas)
example use of pandas with oracle mysql postgresql sqlite
    - updated 9/18/2012 with better column name handling; couple of bug fixes.
    - used ~20 times for various ETL jobs.  Mostly MySQL, but some Oracle. 

    to do:  
            save/restore index (how to check table existence? just do select count(*)?), 
            finish odbc, 

00krishna

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console