Data dodania Pytanie
2017-12-05 04:12 PostgreSQL: /opt/PostgreSQL/9.6/lib/postgresql/plperl.so: undefined symbol: Perl_save_strlen »
I am trying to create plperl extension in PostgreSQL 9.6 (EDB single click executable file) postgres=# create extension plperl; ERROR: could...
(0) odpowiedzi
2017-12-04 17:12 Can we define a GROUP_CONCAT function in PostgreSQL? »
I have several lines of SQL code for my legacy database with GROUP_CONCAT statements, as in: SELECT SUM(age), GROUP_CONCAT(sal) FROM Users; In Post...
(2) odpowiedzi
2017-12-04 10:12 Run Batch File In postgresql in single click »
Hello Experts I have made batch file to run query in postgresql it works fine after pressing enter key 4 times without typing. 1-server, 2 database, 3...
(1) odpowiedzi
2017-11-29 11:11 Postgres query to fetch records from table having a column of type Array of Objects »
I have a table having two properties called id and categoryArray where id is of type number and categoryArray is a jsonb[] column and schema is as men...
(0) odpowiedzi
2017-11-25 15:11 Replace latitude to longitude »
I am getting polygon geom as text which showing the first longitude, latitude ... I am creating GeoJSON and drawing on leaflet... but leaflet standard...
(1) odpowiedzi
2017-11-25 11:11 No ROLLUP and CUBE in PostgreSQL 9.4? »
I have some queries containing rollup and cube statements. When I run them on a computer with PostgreSQL 9.4 and PgAdmin III, it says that such functi...
(1) odpowiedzi
2017-11-24 19:11 how to upgrade/downgrade bdr1.0.3 postgresql9.4.15 »
testing a system for an offline multi master asynchronous i have 2 machines first: ubuntu server 16.04.3 i386// bdr postgresql 9.4.9// bdr plugin 1....
(0) odpowiedzi
2017-11-24 12:11 Batch file to connect postgres in windows »
Hello expert I am new in postgres and i have to delete data from table1 in single click from batch file. I don't have any idea how to connect database...
(1) odpowiedzi
2017-11-22 13:11 How to know the date of modification of an SP? »
Is it possible to know the date of modification and / or creation of an SP in PostgreSQL 9.4? I need to identify them to upload them next Deploy.- ...
(1) odpowiedzi
2017-11-21 16:11 Updating Postgresql Functions from Powershell - Error Pass thru »
We currently have several servers that are required to be separated for the data. The thing is that the Postgresql Servers are expected to be exactly ...
(0) odpowiedzi
2017-11-21 13:11 Correct way to terminate a postgres replication mode connection »
I have the following code that enables logical decoding in postgres 9.4: pg_recvlogical -h localhost --slot test_slot --create-slot pg_recvlogical -h...
(0) odpowiedzi
2017-11-21 03:11 remove duplicate values given it is false or true »
So if I have a table: col1 | col2 x | f x | t y | t z | t q | f q | t For all the duplicate values I want ...
(2) odpowiedzi
2017-11-20 16:11 Postgresql - SQL to Update a JSONB column type »
I have a table which has a column named "data" of type JSONB. I am trying to come up with a SQL statement to accomoodate the recent model changes. (po...
(0) odpowiedzi
2017-11-20 12:11 Postgres Trigger in specified time »
Hello expert I am working in banking software vendor company and we are working in PostgreSQL database due to load of work in office time(pick hour) I...
(1) odpowiedzi
2017-11-18 00:11 Wrong Calculation by User-Defined SQL-Function »
I have a function defined by CREATE OR REPLACE FUNCTION public.div(dividend INTEGER, divisor INTEGER) RETURNS INTEGER LANGUAGE 'sql' IM...
(2) odpowiedzi
2017-11-17 23:11 postgres query partitioned table on current_date »
I have a table in postgres with 10 millions of rows and it's partitioned per month by a date column 'created_on'. My problem is that I often need to q...
(1) odpowiedzi
2017-11-17 23:11 Postgres - Update Attribute of JSONB type colum »
I have a table which has a column named "data" of type JSONB. I am trying to create a migration script based on the recent model changes. (postgres 9....
(0) odpowiedzi
2017-11-16 23:11 Using \COPY to load CSV with JSON fields into Postgres »
I'm attempting to load TSV data from a file into a Postgres table using the \COPY command. Here's an example data row: 2017-11-22 23:00:00 "{\"i...
(2) odpowiedzi
2017-11-14 07:11 How to use INTO and GROUP BY clause together »
SELECT cast ( SUBSTRING ( CAST ("ProcessingDate" AS text), 5, 2 ) as integer), COUNT(*) INTO resultValue1,resultValue2 FROM "DemoLogs"."Project" ...
(3) odpowiedzi
2017-11-12 16:11 Search for holiday doy IN (string) (Postgresql) »
This work: WITH month AS ( SELECT date_part('doy',d.dt) as doy, dt::date as date FROM generate_series('2017-01-01','2017-01-15', interval '1 day') a...
(1) odpowiedzi
2017-11-12 10:11 bulk insert from a query into table (postgresql) »
I cannot find an answer on this: I want to insert the result of this query into a table 'days': WITH days AS ( SELECT date_part('dow',generate_ser...
(2) odpowiedzi
2017-11-11 22:11 Posgresql Database backup with limited data »
I want to take postgresql database backup with limited data. Details are below. Postgresql 9.4 Database having multiple Schemes to be excect 5 All the...
(0) odpowiedzi
2017-11-11 12:11 Problems with stored procedure in postgreSQL »
I'm doing a stored procedure (function) on a query I already had and I'm going crazy. The original query is this SELECT c.child_id, s.child...
(0) odpowiedzi
2017-11-11 06:11 How to add field at specific place in JSON of Postgresql »
In postgresql, I have to add field in below JSON at stat field {"city": "Paris", "name": "John", "title": "abc", "fields": [ { "ali...
(0) odpowiedzi
2017-11-10 20:11 Change tablespace in restoring time - PostgreSQL »
Is there a way to select what tablespace I want to restore the data and indexes separately in Postgres in the pg_dump command? Like the remap of Ora...
(0) odpowiedzi
2017-11-10 11:11 Add column in postgresql JSON »
I am using postgresql 9.4 I have one json column in the table and it contains the value: "{ "title" : "risk", "name" : "David" }" I have to ...
(2) odpowiedzi
2017-11-08 23:11 postgres database level snapshots and backups strategies »
I am a postgres n00b with a postgres 9.4 instance running multiple databases. I want to take a snapshot of a database (not the complete instance) fr...
(0) odpowiedzi
2017-11-05 22:11 i am getting error when i tried to start kong start [-c /path/to/kong.conf] »
I am getting following error when I tried to start Kong in Ubuntu kong start [-c /path/to/kong.conf] prefix directory /usr/local/kong not found, try...
(0) odpowiedzi
2017-11-04 12:11 Flask SQLAlchemy Connection Pooling not working »
I have the following situation : config.py SQLALCHEMY_DATABASE_URI = 'postgresql://a:a@localhost/a' SQLALCHEMY_POOL_SIZE = 5 SQLALCHEMY_TRACK_MODIF...
(1) odpowiedzi
2017-11-02 13:11 How to show full execution query - PostgreSQL »
I have some heavy queries in my server and I want to copy the full query (more than 1024 characters). But the field from view pg_stat_activity dont ...
(1) odpowiedzi
2017-11-01 18:11 Relation "full_dates" does not exist in postgresql »
I am using postgresql 9.4 when i execute the query below with full_dates as ( select generate_series(0,30) +date '7/1/2017' as fulldate ) selec...
(0) odpowiedzi
2017-11-01 03:11 How can I get a list of allowed values for a postgres constraint check from php »
CREATE TABLE public.tasks( id integer NOT NULL DEFAULT nextval('tasks_id_seq'::regclass), title character varying(255) NOT NULL, status character vary...
(2) odpowiedzi
2017-10-31 11:10 How to select from a table and divide the values with the result of another query in PostgreSQL? »
Consider I have this table: create table currency( currency char(3) PRIMARY KEY, rate ...
(1) odpowiedzi
2017-10-30 23:10 pg-promise upsert on postgresql 9.4.11 »
I've searched extensively and I've not been able to solve this simple issue. I'm programming in nodejs, and using pg-promise to store my JSON file dyn...
(0) odpowiedzi
2017-10-30 13:10 Query with multiple joins - postgres »
I have a postgres query with joins on 8 -9 tables and it takes quite a lot of time. Most of the columns used in the query are indexed (BTREE). Now I w...
(0) odpowiedzi