Questions tagged [PostgreSQL] (1722)

There is a task overflow multiple tables (~10 million rows each / ~ 20 columns) from MSSQL to Postgres. Now I pour them using python+pandas. Poured standard: reading from MSSQL (pd.read_sql()), and the resulting DataFrame is poured into another database(pd.to_sql()). Method working, but it works, in my opinion, quite long -...

Good day! Faced with this problem, there is a Json object where invested another object. How to bind a nested object with id of the external object in one json file. I tried to use annotations with Hibernate but I can't do anything. For example:{ "total": 1, "items": [ { "path": 4444", "id": 34", "nmb": 6, "name": "te...

The task is this: to think of the database for CRM b(backend - Jung, DBMS Postgres), where each user has its own table of services the customer table (and we all know that a person can have multiple rooms, etc., that generates additional tables), etc., but also he may have several, say, companies or branches of companies Ex...

PostgreSQL 11. A sign, for instance:id|login |password|role |disabled|settings| --|---------|--------|-------|--------|--------| 1|admin |1 |admin |false |{} | 2|guest |1 |guest |false |{} | 4|test |1 |manager|false |{} | 5|test2 |1 |manager|false |{} | There is such JSONB:{ "perms": [ 1, 2, 3 ], "qwe": true } How to ...

There is a very large database of articles. Right now they are in html format. Right now, go to PostgreSQL, and had the idea to store text in markdown. The question is, will this use? Right now is ~500GB. If we move everything to the markdown, they will take up less space in the database? When the results on the website the...

Hello, I faced a problem writing to the database. I do not understand what the problem is, I had worked with this module, such problems did not arise. Trying to pass a list in which elements 136. Error %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s...

Conventional indexing works, but real time no. I understand that the index record is updated in the database. But what to do? Of course, the usual entry index does not update.Here in comments I read that there are two ways to update: via sphinxQL and via sphinx.api. I've already set up a search via sphinx.api, and now we ne...

If two requests (read and update) occur within the same transaction READ COMMITED, then, of course, we can't be sure that the update will happen. Data could have changed in another transaction. How about one expression? Judging from the documentation inside the visible expression of the same row. Can we be sure that in the ...

How to fix the error Caused by: org.postgresql.util.PSQLException: ERROR: relation "users" does not exist?table for customers:@Entity @Table(name = "Users") public class User { @Id private String login; private String phone; //link to the photo private String photo; @ManyToMany @JoinTable(name = "USER_Advertisement", ...

Hello! How to do import a demo database in Postgres 11 (demo-big.zip)? What I did : 1. Downloaded demo from the site database (https://postgrespro.ru/education/demodb) 2. tried the command postgres=# \i < file path> (result :No such file or directory) 3. I tried psql-h hostname -d databasename -U username-f file.sql a...