Data dodania Pytanie
2017-09-19 00:09 PostgreSQL: How to write a query for this schenario »
I have this below table. +_______+________+__________+________+ |Playid |billid| amount | Date | +_______+________+__________+________+ |123 ...
(2) odpowiedzi
2017-09-18 11:09 How to query PostgreSQL nested JSONB in deeper level? »
I'm new to JSON/JSONB datatypes and I'm having some problems selecting the JSONB elements from deeper levels. Here is an example table: CREATE TABLE...
(1) odpowiedzi
2017-09-15 09:09 Speed up search for date with subrecords recent date (postgresql) »
I want to find old jobs that is still open with no recent activity. The tables are as following: CREATE TABLE job (jobid int4, jobname text, job...
(2) odpowiedzi
2017-09-13 06:09 Write a shell script for importing file CSV files into a postgres table »
We are using Postgres 9.4. Following is the requirement. Can Anyone share me the shell script for importing CSV files into a table. Which ever CSV f...
(1) odpowiedzi
2017-09-13 06:09 Unable to pass arguments in crosstab function postgres »
I know that I have to pass text to crosstab function in postgres. But somehow I am unable to do it. I am not sure what am I doing wrong please Help. T...
(1) odpowiedzi
2017-09-12 16:09 Postgresql select 5 rows even if there is 3 row of data »
How to Select 5 row even if there is 3 row of data and next 2 row should be empty row. ...
(2) odpowiedzi
2017-09-12 16:09 Alternative for EXTERNAL TABLES in PostgreSQL »
I'm having a question in external table concept in PostgreSQL. I'm using Enterprise version (EDB). CREATE OR REPLACE DIRECTORY bdump AS '/u01/app/ora...
(0) odpowiedzi
2017-09-12 14:09 restrict the number of connections in postgres using an ip address »
Is it possible to restrict the number of connections in postgres, using the ip address of machine, since i'm not able to find which ip address is tagg...
(1) odpowiedzi
2017-09-11 15:09 json error when pass it from php to javascript »
When i retrieve data from table with json field then it comes as text. And i store it to an object property by PHP. My problem is when i call that obj...
(0) odpowiedzi
2017-09-11 13:09 Nested Filration not working in postgres query »
This is my json which is stored in postgres table with json type {"layer_name":"rooms","properties":{"fillOpacity":1,"strokeColor":"#606576","id":"WK...
(0) odpowiedzi
2017-09-10 20:09 postgres - insert gen_random_uuid() for the column "key" if the count(key) < 1 »
Generate gen_random_uuid() for the column key if there count(key) < 1 My table name is keytable and column is key. I am using the below insert st...
(2) odpowiedzi
2017-09-09 10:09 java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null' for Postgres database »
I am using JNDI datasource to connect to Postgres database. This is the code to of my ServletContextListener public void contextInitialized(ServletCo...
(0) odpowiedzi
2017-09-07 15:09 The table column "id" cannot auto-generate although I use @SequenceGenerator and @GeneratedValue »
I use postgreSQL and Spring Boot. Here is part of my java code.: @Entity @Table(catalog = "postgres2", name = "user_info") @SequenceGenerator(name = ...
(0) odpowiedzi
2017-09-07 10:09 How to embed postgres database with a application »
I am looking for a way to ship my java application with its embedded postgres database like H2/SQLite. Application is quite complex and its carry ove...
(0) odpowiedzi
2017-09-06 14:09 Postgres - How to create an alphanumeric sequence like AAAA0000 and so on »
I want to create an alphanumeric sequence like this: AAAA0000 AAAA0001 AAAA0002 AAAA0003 . . . AAAA9999 AAAB0000 AAAB0001 and so on I have create...
(1) odpowiedzi
2017-09-05 00:09 ERROR: more than one row returned by a subquery used as an expression »
I am doing an example from the pgrouting a Practical Guide book but with my own tables and I have run into this error. I have used LIMIT 1 to avoid th...
(1) odpowiedzi
2017-09-04 22:09 Postgres Group and order by range (specific values) »
I have a table like this: id simcard simcard_order 80769 56407503370245588410 1 80788 66329183922439284822 2 80803 209...
(1) odpowiedzi
2017-09-01 18:09 Why does vacuum analyze change query plan while analyze does not? »
I wanted to utilize the power of index-only scans in Postgres and experimented with one table: CREATE TABLE dest.contexts ( id integer NOT NULL, ...
(0) odpowiedzi
2017-08-31 20:08 Comprehending ALTER DEFAULT PRIVILEGES »
I have reviewed this well-asked and answered PG permission question, and I use it as a starting point for my question: https://dba.stackexchange.com/q...
(1) odpowiedzi
2017-08-31 13:08 Get the row with the max value in sql »
I want to get the row with the maximum value on a column. I my case I want to ptint only X that has 31. This is my code and also the output. create t...
(2) odpowiedzi
2017-08-30 20:08 Why can 'create table' in Postgres take several seconds? »
In my project we have to sometimes copy all the data from one schema into another. I automated this by simple truncate / insert into select * script, ...
(0) odpowiedzi
2017-08-30 16:08 Check if data has a default length and it's numeric in sql »
In my table I have a column that is a code of 6 digits. myCode CHAR(6) PRIMARY KEY CHECK ( SUBSTRING ( myCode ,1 ,1) >='0' AND SUBSTRING ( myCode...
(2) odpowiedzi
2017-08-29 12:08 PostgreSQL query to find total number of objects and its count »
i need to check number of object inside PostgreSQL database and its count.so please tell me query to count total number of object and its count. ...
(0) odpowiedzi
2017-08-29 07:08 Not connecting to database through java »
Actually I am trying to insert values from java servlet to postgres DB but they are not inserting. Thanks in advance. My html page is <div class=...
(0) odpowiedzi
2017-08-28 12:08 PostgreSQL 9.5 installation using ./configure and using installer and yum difference »
I want to know difference between PostgreSQL installation types ./configure and using run installer and yum installation? ...
(0) odpowiedzi
2017-08-28 03:08 error postgresql 9.4 when dumping data »
I have error like at the picture when I dump the data. I change ssl_renegotiation_limit=0 but I have same error. I have error pg_dump: Dumping th...
(0) odpowiedzi
2017-08-27 21:08 POSTGRESQL ERROR:more than one row returned by a subquery used as an expression »
SELECT (SELECT vch_message FROM TABLE1 WHERE vch_message like 'DONE%' ) as Status, (SELECT vch_Type FROM TABLE2 WHERE...
(1) odpowiedzi
2017-08-26 18:08 Cannot create temporary table in view definition PostgreSQL »
CREATE VIEW viewRebalancingLog AS CREATE TEMP TABLE newSessionID ( ilog_id INT,vch_service_name VARCHAR(200), vch_service_id VARCHAR(200),iuser...
(1) odpowiedzi
2017-08-25 19:08 Postgres BDR - ALTER COLUMN TYPE works on some nodes but not on others »
I have a BDR group with 4 nodes. I'm having problems applying a DDL command to change the type of a column in a table that is not a member of any repl...
(0) odpowiedzi
2017-08-24 13:08 Want to create user defined aggregate function in postgressql »
I want to create an aggregate function which will return same value which is passed to it mostly int or bigint type of value. The purpose for doing t...
(0) odpowiedzi
2017-08-24 08:08 Postgresql, get value for Index[0] in select command »
I am struggling with a Postgresql query. Please refer to the image uploaded with this post. I am not getting any value at Index[0] for a float[] typ...
(0) odpowiedzi
2017-08-23 17:08 Where is bdr.remove_bdr_from_local_node()? »
I'm trying to remove a node from a PostgreSQL-BDR group. The documentation says to use remove_bdr_from_local_node. It's documented, but missing. ht...
(0) odpowiedzi
2017-08-23 11:08 Group by specific column in postgressql »
I trying to get a count of person depending on the org_id. Let's say I have 10 people in my people coming in from different organization. I want to ...
(2) odpowiedzi
2017-08-23 08:08 Multiple database backup using pg_dump »
Is it possible to backup multiple databases with a single pg_dump command, instead of running a pg_dump command for each database ...
(0) odpowiedzi
2017-08-19 15:08 PostgreSQL JSONB versus keeping a separate table »
I'm thinking through a database design and I was wondering if anyone could chime in. I have some structured data that I will occasionally be filtering...
(0) odpowiedzi