Questions tagged as 'postgresql'

Tagged questions
1
answer

What SQL Script in Postgres to return the Functions of a Schema? [closed]

What SQL Script in Postgres to return the Functions of a Schema with its input parameters?     
asked by 31.12.2018 / 15:11
1
answer

Mount SQL with options

I'm using PostgreSQL on a system of extensions and I have two tables here. One that stores the extensions and the other one that stores the permission to connect these extensions. This second table is structured like this: InthesystemImou...
asked by 05.02.2018 / 19:12
2
answers

How to send email to each new record?

I'm using Postgres 9.6 in a project and one of the requirements is for the system to send an email to each new client. 1 - Trigger is a good way to do? 2 - When it comes to performance. What would be the impact on sending these emails...
asked by 29.06.2018 / 14:42
1
answer

Clone DataSet (TZQuery) in Delphi 7

Hello, I have a delphi application that does the following: It makes a query in the PostGreSQL database using the Zeos TZQuery / TZConnection components, then it traverses the result by writing it to another table, that table with columns identic...
asked by 04.07.2018 / 18:43
2
answers

Revoke in TEMPORARY TABLE in PostgreSQL, is it possible?

Is it possible to give%% (Privilege Removal) so that users do not create temporary tables? The REVOKE I need to keep, however, I need to block CREATE TABLE . Is it possible?     
asked by 25.01.2018 / 12:22
2
answers

Query with join

I have a problem in the query to generate a report. I made a JOIN of the ordering table (which will get the report) with the table of customers and products. Until then everything worked, but he hardly shows all the requests, only shows the firs...
asked by 17.11.2017 / 12:58
2
answers

Help to simplify query sql query

I have a huge sql query: select l.no_cidadao, extract(year from l.dt_cad_individual) ano, extract(month from l.dt_cad_individual) mes, date_part('year',age(now(), l.dt_cad_individual)) diferenca from tb_unidade_saude p, tb_cds_cidadao_resposta...
asked by 09.03.2018 / 13:20
1
answer

Special character error in Java

I have a problem here and I did not find anything to solve on the internet, if you could help me, I would be extremely grateful. Well, come on, I have a web application in java that I use Spring Boot + JSP. The problem is this: I have two app...
asked by 31.07.2017 / 19:18
3
answers

How to create an incremental Update sql command

I have a Estoque table where today there are already many rows of records already registered, how can I do an incremental update to populate a column that added the table now? Produto | N_Serie | Etiqueta A | 123 | NULL...
asked by 27.07.2017 / 15:16
2
answers

Trigger that updates record in a table

I need to update an X table whenever there are any changes in the Y table. I have found numerous examples of how to save the changed records in the Y table, both when a record of the X table is deleted and when it is changed or inserted, but my...
asked by 11.05.2017 / 20:52