postgresql tag

79 questions


2 answers
42 views
0
How Do I Use ICU Collation on a PostgresSQL Server Installed in Windows OS Like CentOS?

How do I use ICU Collation on PostgresSQL server ver.10 that I installed on Windows OS like CentOS?We would like to trace this article.

2 years ago

1 answers
46 views
0
About Locking Postgresql Backup

Hello, I do backup every day at work, but I heard that backup is the lowest access share mode.If it's backup, I think it's pg_dump or pg_dumpall, but I can't find it when I look for documents online.I...

2 years ago

1 answers
98 views
0
How to use JDBC to join and store values in entity

I am currently learning JDBC for the first time.For example, if you run a select statement and create an entity class to store the returned values, I would like to ask you a question about how to do i...

2 years ago

1 answers
111 views
0
I'd like to find the value from the array type column to array.

There is a table as below.Books Table-----------------------COLUMN NAME | TYPEid | integername | character varyingsubjects | character varying [] subjects array types when is stored as the {educat...


1 answers
75 views
0
Postgresql cannot be sorted in Korean order.

SELECT * FROM table_name ORDER BY title but the title cannot be sorted in Korean order and can be sorted as it pleases.

2 years ago

1 answers
47 views
0
An internal error occurs when writing postgis, django in postgresql. How do I resolve the error that I can't load the library?

Running python3 manage.py migrate in django django.db.utils.InternalError: could not load library /usr/lib/postgresql/9.5/lib/postgis-2.2.so: /usr/lib/liblwgeom-2.2.so.5: undefined symbol: GEOSClipByR...

2 years ago

1 answers
109 views
0
The phenomenon where null appears at the top when sorting from the large number in postgresql

I'm trying to sort it by score and look at it from the top one by one, but the null value comes out at the top. I'm going to exclude the null I put where('score is not null') but can't I do it at once...

2 years ago

1 answers
93 views
0
I have a question to test postgresql performance.

I want to do a performance test for postgresql.Ubuntu 16.04 was installed on the virtual machine to test the postgresqlinsert,update query statement.The point here is to test with the latest version o...


2 answers
110 views
0
Python, I want to know how to remove the table name when loading SQL data.

The values of the table named Student currently in PostgreSQL (DB) using flasqlAlchemy in Python.session.They're calling me query.When a value is called, the table name and attribute name are grouped ...

2 years ago

1 answers
43 views
0
Postgresql I have a recent date inquiry question.

There are two tables./*article table*/article_code / article_company / article_name / article_standard / article_unit / article_qauntitya004 Sungsim Medical Device Disposable Injection 15cc 1 BOXa005 ...

2 years ago
« - 7 - »

© 2024 OneMinuteCode. All rights reserved.