79 questions
Hibernate 5.0.9 version Dialect is using postgresql. To use the new java.time package in Java8, add jackson-datatatatype-jsr310 dependency and use it.When the field is declared and DDL is automaticall...
I am currently using postgresql 9.4 with postgis 2.1. I'm trying to make an application with a long storage.
Product ------FK----> Purchase ListIf the product on the purchase list is deleted, the purchase list is supposed to be deleted. Is it the right way not to delete the purchase list?Or is it right to...
I am using Postgresql DB.I want to read the created_at column value and check how many hours of row it was created.select EXTRACT(HOUR FROM (NOW() - created_at)) as agefrom tableThe prices are coming ...
The background of knowing the problem is that when selecting, the index was clearly created in consideration of the corresponding select statement, and in development db (local db), the index scan was...
I'm using a storage and post-grescual.By the way, I want to know how fast the query sentence I made speeds up when there is a lot of data.I used django debug toolbar In this case, I can't figure out h...
I am using postgresql. There is a timestamp type column and an id column.I want to extract it like this. select date, count(distinct(id)) from table group by dateHow do I get the date when I want to u...
I have extracted only the necessary attribute values from the table A and the table B (extracted by Join I would like to make a table by adding extraction as join + new name/other to the new C table.-...
DBeaver is using this and that database.By the way, I want to copy the database that I use by accessing DBeaver from another remote computer.How should I do it?
| « | - 8 - |
© 2024 OneMinuteCode. All rights reserved.