Recent questions tagged postgresql

0 votes

1.4k views

1 answer

postgresql - How to know which partition will be used in Postgres hash partitioning?

Is there a way to know which partition will be used for a new row in a table partitioned by a column ... not giving the correct partition value. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Searching on expression indexes

Searching on expression indexes I'm building an expression index that substrings a source field to avoid overflowing ... it works in Postgres. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

postgresql - dynamic query postgres

I am new to postgres and running following dynamic query EXECUTE 'Select * from products'; I get following ... something basic I m missing See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

postgresql - Improving a function that UPSERTs based on an input array

I am hoping to get some help improving a method for UPSERTing rows passed in as an array. I'm on Postgres ... per function or COPY. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - How to install postgres with NSIS with all parameters?

We have a C# program which uses postgres as its database, so we want to bundle the postgres in the ... separate them in different questions. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

postgresql - Update a table with a trigger after update

I have two tables batch (batch_id,start_date,end_date,batch_strength,is_locked) sem (user_id,is_active,no_of_days) I ... limit is adequate. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

postgresql - biginteger array functions

Are there any available functions for work with big integers? I've found a module intarray, but functions from ... right argument from array) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - Play + Anorm + Postgres - load json value into a case class

I am using anorm to query and save elements into my postgres database. I have a json column which I want ... 'myClass -> myClass, ^ See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

postgresql - Referring to session variables (set var='value') from PL/PGSQL

I can pass variables into PostgreSQL using psql --variable="var='value'" <<<'SELECT :var' ...and refer to them ... ":" How can this be resolved? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Working with jdbc jar in pyspark

I need to read from a postgres sql database in pyspark. I know this has been asked before such as here, here ... available in version 1.6.1. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - Share connection to postgres db across processes in Python

I have a Python script running as a daemon. At startup, it spawns 5 processes, each of which connects to a ... is the right thing to do? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Why is SELECT without columns valid

I accidently wrote a query like select from my_table; and surprisingly it is valid statement. Even more ... cared to programatically restrict? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - connect to postgres server on google compute engine

I have searched for this everywhere but after an hour and a half of searching I've not found anything relevant. ... about it? Thanks in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Postgres just randomly stopped working (Rails, PGSQL.5432)

I've been using the same Postgres database in this same app for a month with no problems, and I didn't change ... and (2) how to fix it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - How to switch databases in postgres?

In SQL Server, I use: use database_name Go Select * from table_name In postgreSQL, I still use: connect database_name ... do help me? Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Django Migrations Says Database Backend Isn't Available

I'm trying to upgrade a Django 1.6.2 application to 1.7.10. I'm running PostgreSQL on my ... was: cannot import name BaseSpatialOperations See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Counting chars in sequences via SQL

I have a database with a sequence table. Each (amino acid) sequence in this table comprises of 20 different chars ... will be faster with SQL. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - SQL function very slow compared to query without function wrapper

I have this PostgreSQL 9.4 query that runs very fast (~12ms): SELECT auth_web_events.id, auth_web_events.time_stamp, ... time: 0.101 ms" See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - Get fatal error: server could not be contacted when running pgAdmin4. 'NoneType' object has no attribute 'value'

I have a fresh install of windows where I am trying to install Postgres and pgAdmin4. I did a fresh ... suggested in them without resolution. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - SELECT or PERFORM in a PL/pgSQL function

I have this function in my database: CREATE OR REPLACE FUNCTION "insertarNuevoArticulo"(nombrearticulo character varying, ... about the problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k views

1 answer

postgresql - sql: converting argument $1 type: unsupported type []int, a slice of in

Have this: somevars := []int{1, 2, 3, 4} rows, err = db.Query("SELECT c1,c2 FROM table"+tid+" WHERE ... a slice of arguments work with lib/pq? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

postgresql - INSERT INTO ... RETURNING - ambiguous column reference

Can someone politely explain this craziness? INSERT INTO "dbo"."UserProfile" ("FirstName") VALUES('John') RETURNING ... be ambiguous in any way. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - postgres change jsonb[] to jsonb

I use postgres9.4, and there exists relation "Patients" has column "contact" with type jsonb[], how to ... "relation": "your_relation"}"} See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

955 views

1 answer

postgresql - Are there any options to a join table for many-to-many associations?

Let's say I have two tables with data that isn't supposed to change through the use of my application (i. ... simplify this process in any way? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Matching algorithm in SQL

I have the following table in my database. # select * FROM matches; name | prop | rank ------+------+ ... requirements How can I do this in SQL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - SQL INNER JOIN over multiple tables equal to WHERE syntax

I have two PostgreSQL queries which connect multiple tables: First: SELECT iradio.id, iradio.name, iradio.url, ... are processed within 2ms. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

973 views

1 answer

postgresql - INSERT a number in a column based on other columns OLD INSERTs

In PostgreSQL I have this table... (there is a primary key in the most left side "timestamp02" which is ... any more ideas. Thanks in advance See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Equivalent to exclusion constraint composed of integer and range

I need to have something equivalent to this exclusion constraint drop table if exists t; create table t ( i int, tsr ... message. How to do it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags