Re: [Tutor] help with postgreSQL and .csv

2013-09-03 Thread Peter Otten
Ismar Sehic wrote: > hello. Ismar, please post in plain text. The markup appears as funny stars over here. > i wrote the following code, to insert some values from a csv file to my > postgres table : > > *** > *import psycopg2* > *conn = psycopg2.connect("host = ***.***.***.*** user=**

Re: [Tutor] help with postgreSQL and .csv

2013-09-02 Thread R. Alan Monroe
> my goal is to make it write all the picture url values separated by > a ';' in just one field and to input the data correctly.   I haven't used postgresql much. Could it be you're just missing path_picture as part of your data value? i.e. UPDATE hotel SET path_picture = + hotel_url UPDATE hotel

[Tutor] help with postgreSQL and .csv

2013-09-02 Thread Ismar Sehic
hello. i wrote the following code, to insert some values from a csv file to my postgres table : *** *import psycopg2* *conn = psycopg2.connect("host = ***.***.***.*** user=*** dbname = ** ")* *cur = conn.cursor()* *import csv* *with open('HotelImages.csv', 'rb') as f: * *