79 questions
Hello, let me ask you a question.I am re-pasting the index of a table.table_name_login_idx btree(login) WHERE sex='m':bpcharWhat does this :bpchar mean?Sex is character(1).Please give me guidance.
EnvironmentCentOS Release 6.8I installed it with contrib...yum, but the folder contrib is not created in pgsql.When you type the psql command, psql (8.4.xx, server 9.1.xx) appears.Is the postgresql ve...
Please let me know.The psycopg2 returns an error.Source code is #-*-coding:utf-8-*- import psycopg2if__name__==__main__: connector=psycopg2.connect(host=127.0.0.1, database=pdb, user=pgusr, port=532 ,...
#!/bin/sh# variable settingexport BATCH_E=$(cd$(dir$0)/..&pwd)source$BATCH_E/bin/conf/batch.conf# Batch processing typeTYPE='25'# Launching the JAVA$SH_COMMAND $BATCH_RUNNER_SH batch.Dataupd $TYPE...
to verify the inconsistency of transaction processing.In session A, the price is 1000 yen plus 1000 yen to 2000 yen, and After that, I will try to increase the price to 1000 yen and 5000 yen for the B...
I'm asking you because I'm curious about how to use it in practice.try: cursor.execute(create table test( id serial primary key, plainData varchar(10), cihperData varchar(255), nonce varchar(255) ))...
I'd like to create a table with foreign key constraints in the column that is set to the compound main key in PostgreSQL 9.4. What should I do?Currently, I am using SQL as follows --attendcreate table...
What do you want to doI want Rails to aggregate values by group (SUM) and each group's aggregate results to be defined as variables in the controller*After that, we plan to add the defined values to J...
Suppose you are throwing a complicated select statement in postgres SQL and you are not getting that performance.Explaining the select statement explains how postgres performs select, but if you are n...
Assume a relational database using MySQL.For example, how do you manage databases like bulletin boards that users post more and more, but cannot erase?Even if I put an index on it, I'm worried that if...
| « | - 6 - | » |
© 2024 OneMinuteCode. All rights reserved.