Recent questions tagged postgresql

0 votes

2.3k 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 and ANDs. This is what I have so far: ... .name LIKE $1' USING name; END; $$ LANGUAGE plpgsql; See Question&Answers more detail:os...

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

0 votes

646 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 DROPDB. Why would the following commands not delete ... | | | | postgres=CTc/postgres (4 rows) See Question&Answers more detail:os...

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

0 votes

661 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

663 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 object. node_id parent_node name ------- ---------- ... ] } ] }, ... ] } Any suggestion will help. Thanks See Question&Answers more detail:os...

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

0 votes

818 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 adapters for mysql have options that specify ... thanks. any help or direction is appreciated. -h See Question&Answers more detail:os...

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

0 votes

696 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". This user must also own the server ... /pgsql_socket/.s.PGSQL.5432"? ... now what? See Question&Answers more detail:os...

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

0 votes

764 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 instead of copy as I need it to execute as ... .txt" WITH ... ^ in script.php on line 30 See Question&Answers more detail:os...

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

0 votes

504 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 the table is the ID itself, however it ... in the sequence). Any help would be much appreciated. See Question&Answers more detail:os...

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

0 votes

774 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 with the same values as before. Now I ... It works for me, but I don't like it. See Question&Answers more detail:os...

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

0 votes

1.1k 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 hours, SUM(logged_hours) AS logged_hours FROM ( ... AS p ON p.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

1.2k 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 to do is to somehow run a LIKE query on ... of select * from posts where tags @> '"%TAG%"' See Question&Answers more detail:os...

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

0 votes

635 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 tables in both databases? For example: ... t1, mysql.db2,table2 WHERE t1.id=t2.id; See Question&Answers more detail:os...

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

0 votes

610 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. The connection is used periodically, just reading ... ? I'm using postgresql 9.1 and 9.4. See Question&Answers more detail:os...

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

0 votes

802 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, naming and Rails convention. Now I ... default_scope :order=>"id" validate :expense_date... ... See Question&Answers more detail:os...

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

0 votes

686 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 just show you: $stmt = "SELECT * FROM ... , so I hope someone knows! Thank you in advance! See Question&Answers more detail:os...

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

0 votes

735 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, "day" character varying(9) NOT NULL, ... name as a parameter while still keeping Postgres happy? See Question&Answers more detail:os...

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

0 votes

600 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 queried from information_schema.columns. The ... have never done. Appreciated for your help. grassu See Question&Answers more detail:os...

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

0 votes

941 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 is not in a regular pattern. Number ... : COL2A1 COL4A1 COL4A3 COL8A2 COL12A1 COL12A1 COL16A1 COL19A1 See Question&Answers more detail:os...

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

0 votes

626 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 formats, other pgdump options, and ... Any other helpful pgdump/pgrestore suggestions welcome. See Question&Answers more detail:os...

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

0 votes

655 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 maybe ElasticSearch) to improve query ... Which other solution do I have for this problem? See Question&Answers more detail:os...

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

0 votes

1.9k 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 initializing, it just gets stuck and ... .outputEncoding> <java.version>1.8</java.version> <spring-cloud.version>F...

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

0 votes

612 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 the network of the app. I've googled ... . The npgsql driver doesn't work on this sdk. See Question&Answers more detail:os...

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

0 votes

641 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 know if there's any build-in function that ... , then convert back. But I don't like it. See Question&Answers more detail:os...

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

0 votes

931 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 automatized save-to-file process. I am new to ... with just a save-to statement within the sql function See Question&Answers more detail:os...

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

0 votes

619 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 an all or nothing command. If you ... at https://stackoverflow.com/a/51880577/156458 See Question&Answers more detail:os...

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

0 votes

677 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) VALUES (1, 'a') ON CONFLICT DO ... statements, but this would lead to race conditions I think. See Question&Answers more detail:os...

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

0 votes

745 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. I am running postgres on debian. How do ... a step by step instruction including script to do that? See Question&Answers more detail:os...

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

0 votes

895 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 convert the data from ColumnA into ... a built-in function 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