Recent questions tagged PostgreSQL

0 votes

606 views

1 answer

postgresql - Within a trigger function, how to get which fields are being updated

Is this possible? I'm interested in finding out which columns were specified in the UPDATE request regardless of ... in a default value. See Question&Answers more detail:os...

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

0 votes

851 views

1 answer

postgresql - Merging Concatenating JSON(B) columns in query

Using Postgres 9.4, I am looking for a way to merge two (or more) json or jsonb columns in a query. ... possible with a "traditional" query? See Question&Answers more detail:os...

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

0 votes

903 views

1 answer

postgresql - Recreating Postgres COPY directly in Python?

I have a block of data, currently as a list of n-tuples but the format is pretty flexible, that I'd like ... COPY type bulk load in Postgres? See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

postgresql - Create a Postgres database using python

I want to create Postgres database using Python. con = psql.connect(dbname='postgres', user=self.user_name, ... this by creating Python script. See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

postgresql - Errors in evolutions on Heroku

I tried pushing some evolutions to Heroku: 2012-08-30T10:58:00+00:00 heroku[slugc]: Slug compilation finished ... to the new pushed version. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Changing primary key int type to serial

Is there a way to change existing primary key type from int to serial without dropping the table? I already have a ... don't want to delete it. See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

postgresql - Conditional SQL count

What is the best way to create columns which count the number of occurrences of data in a table? ... query, possibly optimizing performance? See Question&Answers more detail:os...

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

0 votes

905 views

1 answer

postgresql - How to get First and Last record from a sql query?

I have a table in PostgreSQL, I run a query on it with several conditions that returns multiple rows, ordered by ... how do I modify my query? See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

postgresql - Inner join & outer join; is the order of tables in from important?

Why is the order of tables important when combining an outer & an inner join ? the following fails with ... archiverel.dnumber = grp.number See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Loop on tables with PL/pgSQL in Postgres 9.0+

I want to loop through all my tables to count rows in each of them. The following query gets me an error: DO ... quote_ident() but to no avail. See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

postgresql - Install pdo for postgres Ubuntu

I am trying to enable the pdo driver for my php installation, but when I runn the command ./configure --prefix= ... package and using php 5.3 See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

postgresql - PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

I've got this PL/pgSQL function which must return some users information. CREATE OR REPLACE FUNCTION my_function( ... do otherwise. Any ideas? See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

postgresql - Custom ORDER BY Explanation

I found this some time ago and have been using it since; however, looking at it today, I realized that I do not ... !=, not = in this situation? See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

postgresql - Python/postgres/psycopg2: getting ID of row just inserted

I'm using Python and psycopg2 to interface to postgres. When I insert a row... sql_string = "INSERT INTO ... ) Can anyone advise? thanks! See Question&Answers more detail:os...

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

0 votes

924 views

1 answer

postgresql - How can I import a .sql file into my Heroku postgres database?

I have a backup sql file from another database that I want to import into Heroku's postgres database. How do you do that? See Question&Answers more detail:os...

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

0 votes

932 views

1 answer

postgresql - Destroying a Postgres DB on Heroku

I want to destroy the database but I'm not sure what the command would be. Does anyone know how to do this? See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

postgresql - Heroku Postgres - terminate hung query (idle in transaction)

I'm using Heroku with the Crane Postgres option and I was running a query on the database from my local machine ... that I can drop the table? See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

postgresql - How to delete an enum type value in postgres?

How do I delete an enum type value that I created in postgresql? create type admin_level1 as enum('classifier', ' ... m using Postgresql 9.3.4. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Check if a Postgres JSON array contains a string

I have a table to store information about my rabbits. It looks like this: create table rabbits (rabbit_id bigserial ... way to do that query? See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

postgresql - Postgres 9.1 vs Mysql 5.6 InnoDB?

Simple question - what would better for a medium/big size database with requirement for compatibility with ACID in 2012 ... . OLTP or OLAP: OLTP See Question&Answers more detail:os...

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

0 votes

622 views

1 answer

postgresql - How can I ensure that a materialized view is always up to date?

I'll need to invoke REFRESH MATERIALIZED VIEW on each change to the tables involved, right? I'm surprised to not find ... I want... I think) See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

postgresql - Find rows with multiple duplicate fields with Active Record, Rails & Postgres

What is the best way to find records with duplicate values across multiple columns using Postgres, and ... in an aggregate function See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

postgresql - How to `sum( DISTINCT <column> ) OVER ()` using window function?

I have next data: Here I already calculated total for conf_id. But want also calculate total for whole partition ... , conf_id My old question See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

postgresql - How do I handle opening/closing Db connection in a Go app?

I have a set of functions in my web API app. They perform some operations on the data in the Postgres ... the connection in every function? See Question&Answers more detail:os...

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

0 votes

693 views

1 answer

postgresql - PL/pgSQL column name the same as variable

I'm new to plpgsql and I'm trying to create function that will check if a certain value exists in table ... such context refers to column name? See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

postgresql - Loop through columns of RECORD

I need to loop through type RECORD items by key/index, like I can do this using array structures in other ... THIS END LOOP; END LOOP; See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

postgresql - Select from a table variable

I am trying to save the result of a SELECT query, pass it, and reuse it in another PL/pgSQL function: DECLARE ... ? I am using PostgreSQL 9.2. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Format specifier for integer variables in format() for EXECUTE?

CREATE OR REPLACE FUNCTION getParentLtree(parent_id bigint, tbl_name varchar) RETURNS ltree AS $BODY$ DECLARE parent_ltree ... name passed? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags