Questions tagged as 'postgresql'

Tagged questions
0
answers

How to store / br and \ n in the database, and display in HTML then when it is called?

I'm storing the description of an offer in the ofe_desc attribute , but even though in TextArea I insert break lines, bank and HTML (when I try to collect the data), they are all shown in a single line. Following codes: <!-- Mostra na...
asked by 29.10.2018 / 20:07
1
answer

A trigger that checks the deadline for all products in the table

Good afternoon to everyone in the community. I'm trying to make a trigger that checks products that have their expiration date and change their status in the table using postgresql     
asked by 27.10.2018 / 14:10
0
answers

How to do a CRUD in the same FORM JSP-SERVLET

I have created a JSP page called TelaAreaCurso where it is composed of two grids, the one on the left is a form with the form and the one on the right a table that lists all the areas of the course registered. Below is the page described: &...
asked by 20.10.2018 / 17:37
0
answers

Consultation in the Moodle bank in order to bring the number of students approved in a certain course

I need to create a script that searches the bank of Moodle for the number of students approved in a given course and the number of students dropping out, I ask the help of experts about the Moodle bank schema for a path in order to assemble my q...
asked by 18.10.2018 / 16:23
1
answer

delete record in dynamic table with php ajax

I have the following PivotTable and I want to delete the records via AJAX / PHP but I can not. I tried this way by passing the line id as the button id but it did not work ... include("dbconn.php"); <script src="jquery.min.224.js"><...
asked by 19.10.2018 / 16:36
0
answers

Postgress Query SQL

Hello. Display the code and description of the group and the quantity of products associated with each of the groups. Order the result by the quantity of products in each group. I have difficulty in how to do this part "and the amount of product...
asked by 10.10.2018 / 17:40
2
answers

Select comparing current date with exact date 1 month ago

I made this select that returns me the amount of records in the last 24h select count(*) from registros where registry_date >= NOW() - interval '24 hours' I need a select that compares the value that is returned in this first query with...
asked by 10.10.2018 / 16:34
2
answers

Doubt in the insertion of data realizing the relationship in another table

I'm trying to insert an Address into the adresses table and refer to a User already registered without Address in the user table, through the _id that is generated when I enter an Address. Return this _id and insert it into the adresses_id colum...
asked by 10.10.2018 / 18:26
0
answers

How to connect to a postgresql database that is in another network?

I have a postgresql database installed on a Raspberry Pi on another network. I made the settings inside pg_hba.conf: host all all 0.0.0.0/0 md5 In postgresql.conf I edited to stay like this listen_adresses ='*' port=80 I downloaded pga...
asked by 16.10.2018 / 14:27
0
answers

Turning rows into columns - PostgreSQL

I have the following Query : SELECT public.tipocontratoempresa.codigoempresa, CAST ((public.tipocontratoempresa.quantidadehorasmensais * 3) AS Integer) as horastrimestrais, to_char(public.dadosmensaisfaturamentos.datainici...
asked by 08.10.2018 / 19:29