Questions tagged as 'postgresql'

3
answers

Convert the date format the user types

Hello, I have the following code to format the date that the user informs and inserts in my bank: $arrayData['data_validade'] = date_format("Y-m-d",strtotime(str_replace('/','-',$this->$arrayData))); But, this date_format works only for t...
asked by 31.03.2015 / 15:30
1
answer

Save Spring Boot request

I'm a beginner in Spring Boot and I need a little help. I want to save an incoming and outgoing request, generating the automatic id and saving the date and time, using docker and Postgres (I do not know if it changes either to say that I'm usin...
asked by 14.07.2018 / 18:07
1
answer

Query to get errors and hits from a student

I would like a query to get errors and hits from a particular student from the following table below:     
asked by 15.05.2018 / 22:15
0
answers

apache / nifi docker and postgresql Driver

I did the apache / nifi pull in the docker hub. Start the container, but I can not configure the connection to postgres, It throws an exception that it can not load the Database Driver. I copied the .jar file from the postgresql driver into t...
asked by 21.06.2018 / 15:36
0
answers

Copy data from one DB to another, whenever you have a new record

I need to copy data from a BD-1 PGSQL to another BD-2 PGSQL whenever I have a new record. I was trying to give a SELECT inside the INSERT but it is failing the connection, I already checked for various posts but I did not find a solution, could...
asked by 08.01.2018 / 17:46
0
answers

PostgreSQL - autovacuum on small table

What would be a suitable setting for autovacuum to act on this table? We have a "sequence" table, it does what sequence of postgres should do, but perhaps by using other banks the development opted for this approach, which is to use a...
asked by 18.01.2018 / 12:27
2
answers

I can not import numeric data or dates with empty fields in postgresql

When any numeric numeric date or date column is blank, import error occurs DATA TO IMPORT: NU_ANO_CENSO|CO_ENTIDADE|DT_ANO_LETIVO_INICIO|DT_ANO_LETIVO_TERMINO|NU_LATITUDE|NU_LONGITUDE 2017|15547000|06/03/2017|29/12/2017|-1.4708028364433|-...
asked by 04.05.2018 / 21:34
1
answer

nodes extraction via postgreSQL

It is possible via commands in Postgres to treat vector data. I have a table with data that represent the displacement of objects and I need to extract final and initial vertex. Is this possible via PostgreSQL?     
asked by 25.04.2018 / 20:16
3
answers

Select postgres between two values

I'm developing a system and I need to perform a select to fetch the% rate a customer will have. First, I check the% of this customer's return checks and I look for another pre-set rate that will be entitled to this return rate in another tabl...
asked by 26.10.2017 / 13:06
0
answers

EF Core Field Description

Good Morning Assuming I have a 'Description' field in the database, how do I via Fluent API to return "Description" (to be able to appear spelled correctly on the screen)     
asked by 26.05.2018 / 07:10