#!/usr/bin/python
# -*- coding: utf-8 -*-
#!/path/to/interpreter
#!/usr/bin/env python
import psycopg2

conn=psycopg2.connect(database='test',user='test',password='abc',port='8080')

cur=conn.cursor()
# EMPLOYEE RECORDS
cur.execute('''select IDCARD,d_Fname,d_father_name,d_address,gender from employee ''')
to '/home/ubuntu/rep/employee.csv' delimiter ';'  csv header;''')

print 'n'
print "Successfully executed"