Tagged Questions

-2
votes
0answers
6 views

Postgresql implementation of data model

I am trying to understand the Postgresql implementation of the relational data model. Could anyone provide a high-level explaination of how its primitives (schemas, attributes, tuples) and operations ...
1
vote
2answers
5k views

PostgreSQL psql insert SQL statements via command line without reopening the remote database server host

I have a large amount of data files to process and to be stored in the remote database. Each line of a data file represents a row in the database, but must be formatted before inserting into the ...
0
votes
1answer
22 views

Liquibase generates bigint IDs instead of varchar

I'm just trying out Liquibase with Dropwizard and Hibernate on PostgreSQL, all latest versions, but I've hit a snag. I was going to use Hibernate's UUID generator for my class IDs, which produces a ...
0
votes
1answer
24 views

incremental export and import postgresql C#

I have a PostgreSQL Database, with one table. Each day, I want to export the data WHERE date='whatever' so it ONLY dump the data I've managed TODAY. Then, I go to another Database, and import that ...
0
votes
1answer
22 views

Capturing meta data about how data was collected in a database [closed]

I have information I'm going to put in a database, but there I need to store meta-data about where the data came from (whether the data was measured or calculated). I have several attributes that ...
0
votes
0answers
23 views

postgresql connection error with qt creator in windows

I have a button on my qui. And when i clicked it, it must be connect databese according to connection infos. here is my code: void MainWindow::on_pushButton_clicked(){ db = ...
0
votes
1answer
44 views

Postgres Version

I have been asked to develop my new application with Postgres 10.0. Before this, I have been developing applications with MsSql and was quite easy even. I searched for the Version 10.0 but didn't find ...
0
votes
1answer
22 views

How to create concurrent databses, So that when one database is down other can work…? [closed]

I have a local application running on LAN. Some times the system having database get shutdown. In such a scenario how to keep application working. Can i have two concurrent database. I am using ...
0
votes
1answer
23 views

postgres - how to choose last transactions per user_id, per transaction type?

i have the following table (raw_data): trans_id,user_id,msg_code,record_time given a time frame (from_time,to_time) i would like to query: get for each user: get the last msg_code of each type. ...
0
votes
1answer
31 views

Proper way to add forgeign keys in db?

So - I've been learning rails for the last 4 months and would like to think that I have a pretty good overview of it. Albeit, there are a few gray areas that I would like to make clearer. One being ...
0
votes
0answers
30 views

“FATAL: database does not exist” on postres, login is not working through app

I have these three steps bellow which I am executing every moment that I need to create a new environment for my app, the step 3 is just part of code... On the first step I create the database, ...
0
votes
1answer
26 views

Postgres Bulk Data Import and Populate Associated Data

I have a Postgres database that gets updated from various external sources several times a day, and each record has fields like company_id and user_id that need to get looked up from an existing table ...
0
votes
1answer
37 views

Neo4j vs (Neo4j + Postgres)

I am developing an recommendation engine and was thinking of saving actual data (email, name, password, etc) in Postgres and saving relationship in Neo4j. But was wondering if this gives any advantage ...
1
vote
3answers
36 views

DELETE FROM … reporting syntax error at or near “.”

I'm trying to delete just one data from my DB, but, when I write the command I keep getting that there's some syntax error, could you tell me where is the error? This are the commands I've tried: ...
-2
votes
1answer
22 views

cant delete data from postgresql

I'm quite new to PostgreSQL, so maybe I'm getting some noob error I cannot recognize, so please, tell me why I cannot get this data deleted. This is what is happening: DELETE FROM userprofile WHERE ...

1 2 3 4 5 … 109
15 30 50 per page