FilesExpand file tree

 master

/

queryusers.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

20 lines (18 loc) · 474 Bytes

 master

/

queryusers.py

Copy path

Top

File metadata and controls

• Code
• Blame

20 lines (18 loc) · 474 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

import psycopg2 as db

conn_string="dbname='dataengineering' host='localhost' user='postgres' password='postgres'"

conn=db.connect(conn_string)

cur=conn.cursor()

query = "select * from users"

cur.execute(query)

print(cur.fetchone())

print(cur.rowcount)

print(cur.rownumber)

print(cur.fetchmany(3))

print(cur.rownumber)

f=open('fromdb.csv','w')

conn=db.connect(conn_string)

cur=conn.cursor()

cur.copy_to(f,'users',sep=',')

f.close()

f=open('fromdb.csv','r')

print(f.read())