Questions tagged [postgresql]

If your question is explicitly for the PostgreSQL database (server or client). Targeting "any" database, rather use the 'database' tag.

55 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Editing the content of a PostgreSQL table through the data output of a query

I am looking for a Windows 7 or OS X program that can query a PostgreSQL table, and let me edit the table by editing the data output of a query. I know how to code it, but I am wondering whether there ...
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...
0
votes
0answers
22 views

Database *data* version migration tool

I have two db servers: local and remote (dev). Remote dev version is being constantly changed including the app static data. While working on my copy I need to modify not only schema but also static ...
-1
votes
1answer
10 views

Building a Data analytics website with PostgreSQL

I need help with someone giving me advice on how do I go about building a data analytics website with data from PostgreSQL. I research on Django framework to help build a data analytics website but ...
-2
votes
2answers
38 views

Software to edit large raw datasets easily for PostgreSQL imports?

I have a few lists of 2 million rows or so consisting of: Name, Address, Phone Number but these have errors like multiple commas in a row. When I import these into postgres as .txt and comma ...