Recent questions tagged PostgreSQL

0 votes

713 views

1 answer

postgresql - How to aggregate matching pairs into "connected components" in Python

Real-world problem: I have data on directors across many firms, but sometimes "John Smith, director of XYZ" ... ')] print(get_cliques(pairs)) See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - postgres jsonb_set multiple keys update

I have DB table with jsonb column. number | data 1 | {"name": "firstName", "city": "toronto", " ... possible to achieve this in single query? See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

postgresql - SQL - Combining multiple like queries

Hey my first question on SO! Anywho... Still relatively a newb at SQL so I think I might be missing something ... help out with that. Thanks! See Question&Answers more detail:os...

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

0 votes

924 views

1 answer

postgresql - In Redshift/Postgres, how to count rows that meet a condition?

I'm trying to write a query that count only the rows that meet a condition. For example, in MySQL I would write it ... 87, 100, 100, 98, 94); See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Order varchar string as numeric

Is it possible to order result rows by a varchar column cast to integer in Postgres 8.3? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

postgresql - How to apply a function to each element of an array column in Postgres?

A Pg query returns an array. I would like to retrieve that with each element formatted to 3 decimal places. How ... like Perl's map function. See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

postgresql - Increment a value in Postgres

I'm a little new to postgres. I want to take a value (which is an integer) in a field in a postgres table ... to move Bill's total to 204? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql error PANIC: could not locate a valid checkpoint record

When I load up the postgres server (v9.0.1) i get a panic that prevents it from starting: PANIC: could not ... record How can I fix this? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - How do I insert multiple values into a postgres table at once?

I have a table that I am trying to update multiple values at once. Here is the table schema: Column | Type | ... ]); How would I do this? See Question&Answers more detail:os...

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

0 votes

893 views

1 answer

postgresql - Postgres: "ERROR: cached plan must not change result type"

This exception is being thrown by the PostgreSQL 8.3.7 server to my application. Does anyone know what this ... from country where code=$1 See Question&Answers more detail:os...

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

0 votes

986 views

1 answer

postgresql - How do I disable referential integrity in Postgres 8.2?

Google results on this one are a bit thin, but suggest that it is not easily possible. My specific problem is ... if Postgres didn't. Thanks! See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

postgresql - Select query with offset limit is too much slow

I have read from internet resources that a query will be slow when the offset increases. But in my case I ... "Execution time: 15691.660 ms" See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - fe_sendauth: no password supplied

database.yml: # SQLite version 3.x # gem install sqlite3 # # Ensure the SQLite 3 gem is defined in your ... dir: /Library/PostgreSQL/9.2 See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - How to pg_dump an RDS Postgres database?

How can I connect to my RDS instance using pg_dump? This is the instance's endpoint: <long public dns ... or doing something else entirely? See Question&Answers more detail:os...

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

0 votes

909 views

1 answer

postgresql - What is a "Bitmap heap scan" in a query plan?

I want to know the principle of "Bitmap heap scan", I know this often happens when I execute a query with OR ... behind a "Bitmap heap scan"? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Embedded Postgres for Spring Boot Tests

I'm building a Spring Boot app, backed by Postgres, using Flyway for database migrations. I've been ... embedded version of Postgres? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Creating a database dump for specific tables and entries Postgres

I have a database with hundreds of tables, what I need to do is export specified tables and insert statements ... Any help will be appreciated. See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

postgresql - Using psql how do I list extensions installed in a database?

How do I list all extensions that are already installed in a database or schema from psql? See also ... extensions that PostgreSQL ships with See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click ... pgAdmin. Can you help me please? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - CASCADE DELETE just once

I have a Postgresql database on which I want to do a few cascading deletes. However, the tables aren't set ... explicitly just to be sure. See Question&Answers more detail:os...

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

0 votes

935 views

1 answer

postgresql - list Postgres ENUM type

The suggested query to list ENUM types is great. But, it merely lists of the schema and the typname. How ... ,'email','phone_call','broadcast' See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

postgresql - Writing query for multiple tables in php

I am writing my last query for my homework, but I am stuck on it right now. This query requires me to ... default 0 life_expectancy | real | See Question&Answers more detail:os...

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

0 votes

882 views

1 answer

postgresql - Fixing column "columnname" does not exist pgsql in database. Double quote vs single quote error

I have a table review(movie_id, user_id, reviewtext, date, time, likes, status)/ I get the error column "exist ... can do is alter the database. See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

postgresql - SQL query column does not exist error

I'm totally new in this area please tell me how to fix my problem. when I write this query "SELECT * FROM ... exist. Why my query throws error? See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

postgresql - Getting Error of "Connection Timed Out" and "OS Error"

Launching libmain.dart on Gorgeo 4GL in debug mode... libmain.dart:1 √ Built buildappoutputsflutter-apkapp-debug.apk. V/ ... .2.2, port = 56162 See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

postgresql - SELECT raises exception in PL/pgSQL function

I want to implement a loop inside a function but I receive this error: ERROR query has no destination for result data ... ; Why? How to fix it? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Selecting multiple max() values using a single SQL statement

I have a table that has data that looks something like this: data_type, value World of Warcraft, 500 Quake 3, ... would I go about doing this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Use function variable in dynamic COPY statement

According to docs of PostgreSQL it is possible to copy data to csv file right from a query without using an ... no such column 'my_var'. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags