Posts by Jessica Costa • 381 points
9 posts
-
4
votes1
answer339
viewsQ: Tempo datetime.datetime.now()
I’m making a script where I measure the performance of a query in a database. The code is as follows:: start = datetime.datetime.now() //CONSULTA AQUI end = datetime.datetime.now() print "Time…
-
1
votes0
answers78
viewsQ: Optimization of SQL query time
I have a database that stores precipitation marked by various sensors on certain dates and times over the course of a year. I am making a query, to search all records marked by a single sensor, with…
-
0
votes1
answer42
viewsQ: date manipulation in postgresql
I have a database with several records, since 2001 until 2010. How do I select all tuples with dates after the day 2001-05-02? Data is of the type character varying(254).…
-
0
votes1
answer2321
viewsQ: Fetchall() limited in python
I’m making a code that makes a query in postgres and returns in a list, but this is giving memory error. The part of the code that does this: c = conn.cursor() c.execute("SELECT latitude, longitude,…
-
1
votes0
answers56
viewsQ: python relationship in neo4j
I have the following code where I am migrating a relational database to neo4j. I made a node for each latitude and longitude sensor and a distinct node for each rainfall recorded in my database. db…
-
2
votes2
answers626
viewsQ: Separate file lines into tokens - Python
I want to read the line of a file and store each word or information in a vector position. Ex: "18-10-2015 00092 65534". line[1] = 18-10-2015 line[2] = 00092 line[3] = 65534 OBS: tab between strings…
pythonasked Jessica Costa 381 -
1
votes1
answer465
viewsQ: Extracting postgresql data to file
I am trying to extract data from a table to a file with the following command: COPY historico TO '/home/jessica/teste.txt'; But the following error occurs: ERROR: could not open file…
-
4
votes2
answers300
viewsQ: Import . sql from Postgresql in Neo4j
I have a Postgresql . sql backup file and want to import that file to Neo4j (graph database). How do I?
-
13
votes4
answers10456
viewsQ: Workbench for Postgresql
Does anyone know of a Workbench for Postgresql? I need it because I don’t want to mess with postgres per command line.
postgresqlasked Jessica Costa 381