Data dodania Pytanie
2017-08-15 15:08 Postgres query running very slow »
SELECT st.id FROM station st, strike s WHERE s.srikedatetime > (current_timestamp - interval '20 seconds') and srikedatetime < current_t...
(2) odpowiedzi
2017-08-15 08:08 Detecting the change on the certain column in the history table »
Consider the following data: history.data ======================================= id |data_id| col1 | col2 | date ---+-------+-------+-------+-----...
(3) odpowiedzi
2017-08-14 19:08 Using python psychopg2 to get a count on all variables in the database that contain a specific string »
I have a list, words = [word1, word2, word3, ...] I want to use sql to return the number of times each word appears in Column A of an sql file. I can...
(1) odpowiedzi
2017-08-14 05:08 Storage consumption RDS Postgres »
Is there any way to see whats in the RDS storage? I have a Postgres instance on RDS. The Database in itself is very tiny, around 50MBs but the storage...
(0) odpowiedzi
2017-08-11 16:08 storing client datimetime with zone in postgresql table »
I want to store visitor last visit to my flask web page. for which I created db class TempTable(db.Model): __tablename__ = "tempTable" time...
(1) odpowiedzi
2017-08-11 15:08 postgress : SQLQuery : Week start and End date »
How to find out start and end date of week when Event Date is known. DATEADD(dd, -(DATEPART(dw, eventDate)-1), eventDate) [WeekStart] DATEADD(dd, 7...
(1) odpowiedzi
2017-08-10 11:08 classoid column in pg_description »
What is the "classoid" column in pg_description table? I see it changing for different kinds of objects like table, function etc., The PostgreSQL Off...
(1) odpowiedzi
2017-08-09 12:08 How to retrieve csv data stored in a 'text' field into another table in postgresql? »
For example Please suggest a solution ...
(1) odpowiedzi
2017-08-04 16:08 Postgres create temp table for each request from web application and that temp table will be accessible across all functions inside Postgresql.? »
I want to create a temp table for each request from a web application. The temp table should be accessible to all the functions present inside the Pos...
(0) odpowiedzi
2017-08-03 08:08 geometry matching and update »
I am trying to match geometries from two tables and update one table based on the match. But this is taking huge time. Table1 +-------------+------...
(1) odpowiedzi
2017-08-02 10:08 How to call table function from another function in PostgreSQL? »
I am new to PostgreSQL. I have a function CREATE OR REPLACE FUNCTION func1 ( a_person_id integer) RETURNS TABLE (granted_group_id varchar(10)) AS $b...
(2) odpowiedzi
2017-08-01 09:08 Not able to create Collation on windows »
Hi I am trying to create collation on Windows but not able to create it, I getting error as shown in screenshot. I am using deafult POSIX collati...
(1) odpowiedzi
2017-08-01 07:08 How to use join with aggregate function in postgresql? »
I have 4 tables Table1 id | name 1 | A 2 | B Table2 id | name1 1 | C 2 | D Table3 id | name2 1 | E 2 ...
(1) odpowiedzi
2017-07-30 22:07 Return model with laravel when it was created »
I need to send a new model saved as json to front but I can't see column organizationid in response This is my model class Organization extends Mod...
(2) odpowiedzi
2017-07-29 15:07 SEGFAULT when creating own index in postgresql for POINT3DZ »
I'm trying to write my own index for 3d points - POINT3DZ (using pgis and postgres 9.4). I have written a code similar to spgquadtreeproc.c [1] This...
(0) odpowiedzi
2017-07-29 10:07 How to done with BDR Offset Incremental auto »
Hi i am done with BDR configuration with node1 and node2 on centos 6.4 with postgres 9.4 and BDR with 1.0.9. my concern is if i set the nextval on nod...
(0) odpowiedzi
2017-07-27 20:07 Spring JPA Sorting and Paging with PostgreSQL JSONB »
I am using Spring JPA in order to manage my PostgreSQL data. This data makes heavy use of the jsonb data type in PostgreSQL 9.4. My table (called job...
(0) odpowiedzi
2017-07-25 18:07 psycopg2 kills query after 3 minutes »
I am using psycopg2 version 2.6.1, whenever I run a query to a remote server, if its less than 3 minutes it will run perfectly, but if it runs for mor...
(0) odpowiedzi
2017-07-24 19:07 Custom query on sequelize seeder »
Any one know how to custom select query on sequelize seeder I have tried two ways, but no one work First attempt up: function(queryInterface, Seq...
(1) odpowiedzi
2017-07-23 16:07 What should I do with my pg_log? »
I have two database server, one for main usage and the second is for standby. The log file is being recorded every day. About last week, when I found ...
(1) odpowiedzi
2017-07-22 01:07 Postgres 9.4.12 Slow queries »
I'm having slow queries with my postgres in a table with 9 million rows. Query: EXPLAIN (ANALYZE, BUFFERS) SELECT date_point, geo, alarms, status FRO...
(1) odpowiedzi
2017-07-21 11:07 postgres, create database from template on external server »
I have two servers with same version of postgres(9.4). I would like to make fast clone database (backup and restore). As i understand "create database...
(2) odpowiedzi
2017-07-20 01:07 Return first entry in table for every row given a specifc column sort order »
I have a table with three columns, hostname, address, and virtual. The address column is unique, but a host can have up to two address entries, one vi...
(2) odpowiedzi
2017-07-18 21:07 How to match Object field with String in in Django template? »
Initially, when I am saving this 'status' field in database it is (=models.CharField(max_length=200)) So, Now When I am trying to get this data in HT...
(0) odpowiedzi
2017-07-18 17:07 Expand a jsonb array proprietie »
By selecting from a jsonb field in a pg3 database, i'm getting results like this one: res text ["card", "dog", "chair"] ["house", ] ...
(0) odpowiedzi
2017-07-18 13:07 get till end of string after first space »
I need to split a string as follows, when I try with with split_part no luck select split_part('8 HAMPSHIRE RD',' ',2) Expected output: HAMPS...
(2) odpowiedzi
2017-07-17 12:07 sequelize include returns only one result »
I have a Users table and a Groups table, when I retrieve a single user, I want to get a list of all the groups that user belongs to. I created a joins...
(1) odpowiedzi
2017-07-14 17:07 how to get multiple rows as a parameter - postgresql »
In Postgresql,I have a problem to insert json record into table. [{"cls_id":54,"ins_count":57,"dbase_id":1,"select_db":[1],"total_count":1}, {"cls_id...
(0) odpowiedzi
2017-07-14 04:07 Postgres 9.4 sql query timeout »
Below query times out after adding these two lines or any single one of it AND final IS NOT NULL ORDER BY tmodified ASC Query keeps running more t...
(2) odpowiedzi
2017-07-13 20:07 "duplicate key value violates unique constraint" despite existence check »
On PostgreSQL 9.4. I was surprised to see that error in our server logs, pinpointed to the sole statement inside a pl/pgsql function: CREATE OR REPL...
(1) odpowiedzi
2017-07-12 09:07 pg_dump: aborting because of server version mismatch »
I am running ubuntu 14.04. while backing up a database on postgreSQL i am following error: /usr/bin/pg_dump --host 127.0.0.1 --port 5432 --username "...
(1) odpowiedzi
2017-07-12 06:07 RR MILLENNIUM equivalent in Postgres »
Is there a built in function in PostgreSQL 9.5 version to calculate the appropriate century/millenium? When I use birth_date::TIMESTAMP from a table,...
(1) odpowiedzi
2017-07-11 15:07 EF postgre check if database exists »
With the Entity Frameworks' DbConetxt I am trying to check if the database exists with the query below. public async Task<bool> CheckIfExistsAs...
(1) odpowiedzi
2017-07-10 19:07 Efficiently join tables by expression »
I apologize for the vague question, I'm not entirely sure how to convery what I am wondering. Let's say I want to find all values in table t1 that ca...
(0) odpowiedzi
2017-07-10 10:07 Delete a record if the associated Join entry does not exist »
I'm trying to delete a record from a table if the parent table record does not exist. The table in question are merchants and merchant_configuration...
(2) odpowiedzi