Recent questions tagged Postgresql

0 votes

3.7k views

1 answer

postgresql - Syntax error in dynamic SQL in pl/pgsql function

I am using pl/pgsql in PostgreSQL 10, to create complex queries. I am testing a query with a couple of JOINs ... name; END; $$ LANGUAGE plpgsql; See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Can't delete database

I'm new to PostgreSQL and am having a problem with what I perceive to be a simple command DROP DATABASE and ... postgres=CTc/postgres (4 rows) See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - Can the Postgres data type NUMERIC store signed values?

In PostgreSQL, I would like to store signed values -999.9 - 9999.9. Can I use numeric(5.1) for this? Or what type should I use? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Postgres - Convert adjacency list to nested JSON object

I have a table with this data in Postgres and I am having a hard time to convert this in to a JSON ... } Any suggestion will help. Thanks See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - does rails postgres adapter support ssl?

i'm trying to configure a rails app to remotely connect to a postgres db. i've noticed that the connection ... or direction is appreciated. -h See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - Can't get Postgres started

brew install postgresql Initialize... [~] initdb The files belonging to this database system will be owned by user "pma ... 5432"? ... now what? See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

postgresql - Problems while importing a txt file into postgres using php

I am trying to import a txt/csv file into my postgres database from php using "copy" command. I cannot use COPY ... ^ in script.php on line 30 See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Calculate next Primary Key - of specific format

I have a table which holds a list of IDs, and various other columns such as IDName. The Primary Key of ... Any help would be much appreciated. See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - Modify Django AutoField start value

I have and existing database, which I have migrated with SQLAlchemy to a new PostgreSQL database. I moved all primary keys ... I don't like it. See Question&Answers more detail:os...

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

0 votes

2.5k views

1 answer

postgresql - PGError: ERROR: column "p.name" must appear in the GROUP BY clause or be used in an aggregate function

I get an error with this query. Why? I don't understand :( SELECT p.name, p.id, SUM(hours) AS ... .id = results.project_id GROUP BY project_id See Question&Answers more detail:os...

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

0 votes

2.7k views

1 answer

postgresql - LIKE query on elements of flat jsonb array

I have a Postgres table posts with a column of type jsonb which is basically a flat array of tags. What i need ... where tags @> '"%TAG%"' See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - how to access postgres from mysql?

Is it possible to access a Postgres database from MySQL, so that I could run a single query that does joins across ... table2 WHERE t1.id=t2.id; See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - What are the consequences of not ending a database transaction?

I have found a bug in my application code where I have started a transaction, but never commit or do a rollback. ... postgresql 9.1 and 9.4. See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - "PG::UndefinedTable: ERROR: relation does not exist" with a correct Rails naming and convention

I've read a lot of potsts like this, but all the solutions I've seen are in the nomenclature of the models, ... " validate :expense_date... ... See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - How to make dynamic postgres prepared statements in PHP

I'm trying to make some prepared statements in PHP using postgres. It's a bit difficult to explaing so i'll ... knows! Thank you in advance! See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - Using parameter as column name in Postgres function

I have a Postgres table bearing the following form CREATE TABLE "public"."days" ( "id" integer NOT NULL ... while still keeping Postgres happy? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - count (no null values) of each column in a table

I'm looking for a way to get the count of each column in a specific table. The columnnames should be ... . Appreciated for your help. grassu See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

postgresql - How to do sorting on irregular Alphanumeric data in postgres sql

I have the following sample data for a particular column symbol for sample table. (Update:) The data ... COL8A2 COL12A1 COL12A1 COL16A1 COL19A1 See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Which pgdump format is best for small storage size and fast restore?

This a first time foray in PostgreSQL backups (db dumps) and I've been researching the different ... pgdump/pgrestore suggestions welcome. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

postgresql - Notifying postgres changes to java application

Problem I'm building a postgres database for a few hundred thousand products. I will set-up an index (Solr or ... do I have for this problem? See Question&Answers more detail:os...

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

0 votes

3.3k views

1 answer

postgresql - Spring Boot Application gets stuck on "Hikari-Pool-1 - Starting..."

I'm trying to run Spring Boot application connected to PostgreSQL database. However, when it comes to Hikari connection pool ... .version>1.8</java.version> <spring-cloud.version>F...

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

0 votes

2.0k views

1 answer

postgresql - How to connect a C# Windows mobile 6.5 app to a Postgres database?

I'm developing an application for Windows Mobile 6.5 that needs to get and send data from a Postgres database within ... 't work on this sdk. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql date_trunc to arbitrary precision?

postgresql has date_trunc that can truncate the time stamp value to a specific unit, like hour or minute. I want to ... But I don't like it. See Question&Answers more detail:os...

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

0 votes

2.5k views

1 answer

postgresql - Save output from sql function to csv file (COPY) with dynamic filename

I am running Postgres 9.3 on MacOSX. I am trying to add a COPY statement inside a function for an ... -to statement within the sql function See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Does dropping a database have to be done not in any transaction?

From https://wiki.postgresql.org/wiki/Psycopg2_Tutorial PostgreSQL can not drop databases within a transaction, it is ... .com/a/51880577/156458 See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - Run SQL statements in PL/pgSQL only if a row doesn't exist

I want to do something like this in a PL/pgSQL function in Postgres 9.6: INSERT INTO table1 (id, value) ... lead to race conditions I think. See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - cron job to remove old data from postgres on debian

I need to create a cron that runs every night and remove some of the data (older ones) from my database ... including script to do that? See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

postgresql - How to convert a XML into JSONB within Postgres

I have a table, Table1 that contains a XML data type column, ColumnA and another JSONB column ColumnB How do I ... in Postgres that does this? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags