Questions tagged as 'postgresql'

Tagged questions
0
answers

How to update several php postgresql records?

I need to update multiple records at the same time with php / postgresql (also for mysql) through a checkbox and textbox but I can not. The code below only updates the last record's sequence field and does not update the status. The remaining re...
asked by 20.11.2017 / 22:12
0
answers

Group weekend and holiday values for next business day

Well, I have the following problem, I need to group all balance amounts that fall on Saturday, Sunday, or holiday to the next business day. I have a invoices table with the values of saldo and vencimento , and dim_fered with...
asked by 12.09.2017 / 23:33
1
answer

How to Save the Date Field of a Java SE Application in PostgreSql

I need to save these two dates (ALLOCATION DATE and RETURN DATE) from an allocation, where I have the following Allocation Table: CREATE TABLE public.aloca ( alocod serial NOT NULL, alodtdevolucao date NOT NULL, alodtalocacao date NOT NU...
asked by 06.09.2017 / 22:52
1
answer

Error in setting up postgres with wildfly

I've done the postgresql configuration: C: \ wildfly-10.1.0.Final \ modules \ system \ layers \ base \ com \ postgresql \ main I added the files: module.xml postgresql-9.4.1208.jre7.jar The bank has version 9.6 and drive 9.4, can the pr...
asked by 09.09.2017 / 05:54
1
answer

jsonb: how to fetch the value of the same key from all objects in an array?

I have a column of type jsonb that stores objects in an array. I can get the key template of all index objects 0 like this: psql=# select data->'components'->0->'template' as template from page; that returns...
asked by 18.08.2017 / 01:07
1
answer

php connection to PostgreSQL database

Problem when connecting to PostgreSQL database using PHP. When I run the pg_conect() function, the following error occurs Fatal error: Call to undefined function pg_connect() I have already added the path of the dll from postgreSQL...
asked by 19.08.2017 / 20:59
0
answers

Error with Java EE server on JBoss server

Hello. I made a project in NetBeans on a computer and it works normal, but when I try to run the same project on another computer it returns this error: Implantando C:\Projetos\confeccao\dist\confeccao.war {"JBAS014653: Composite operation...
asked by 06.08.2017 / 21:53
2
answers

pass php query value postgresql to modal bootstrap

I want to pass the value of the php / postgresql query to the modal but I am not able to. I have a PivotTable that lists the results. In one of these columns I want to include the modal (popup) button and pass the line id to the modal in orde...
asked by 11.08.2017 / 22:51
1
answer

Import txt to postgresql

I've created the following txt file: 'Granada', current_timestamp 'Grecia', current_timestamp 'Guatemala', current_timestamp 'Guiana', current_timestamp 'Guine', current_timestamp 'Guine Esquatorial', current_timestamp 'Guine Bissau', current_...
asked by 28.07.2017 / 00:46
1
answer

Indexing BD records

Recently I ran a EXPLAIN ANALYZE in my database that is fairly large, about 800,000 records in some tables, and I noticed that the indexing methods adopted were not the best. I've always let the bank decide how best to index the records,...
asked by 07.07.2017 / 22:04