Questions tagged as 'pgadmin'

Tagged questions
0
answers

how to make traces

I have an application whose database engine is the postgres and I have the pgadmin 4 installed but I need to know what tool to create a record of traces made by the user.     
asked by 22.06.2018 / 17:24
0
answers

problems with pgadmin 3

I am trying to create a new server record in Pgadmin 3 I add a name, then the host added localhost port 5432 maintenance DB postgres, username root password of 9 characters and I get this. regards, I am new, postgres, I have kali linux An...
asked by 18.06.2018 / 06:14
0
answers

Trigger between three tables

On the one hand, article table (code_of_bars, price_article), ticket (ticket_id, total_price) and finally the table that relates them formed (id_ticket, code_of_bars). I want that every time an entry is added in formed the price of the ticket is...
asked by 19.05.2018 / 11:24
0
answers

how to prevent pgadmin III from disconnecting from postgresql every 15 minutes or so?

What happens is that I leave the desk for a few minutes and when I want to restart or use pgadmin III again to access my postgresql database, I get an error message saying that the connection has been lost and I have to close the pgadmin and reo...
asked by 26.04.2018 / 18:59
1
answer

Subtract columns from different tables

Companions, I have this because my logic is not giving me. This my query: (select count(distinct (case when sno_personalnomina.codnom::int in (1,2,3,5,6,7,8) then sno_personalnomina.codper end)) as sin_renumeracion from sno_personalnomina...
asked by 22.03.2018 / 16:38
0
answers

Set value within json postgresql 9.4

I have the following problem: I need to do an update within json with the aim of changing " typedata " to a new value that is given to me. { "nametable":"venta", "data":"name":"1", "cols":"Tienda":"typedata":"varchar" }, "Fecha":"typedat...
asked by 23.01.2018 / 20:58
1
answer

I need to keep track record in postgresql

I am doing a database design in postgresql and I need to take the history of the patients, which can go through several categories, the complicated thing is that all the time I must know what were the data that the patient had in each category ,...
asked by 12.12.2017 / 20:48
2
answers

Error creating POSTGRESQL database

I am trying to create a database POSTGRESQL from Pgadmin4 Version2 . I have three different scenarios and I am not able to solve any of them. My first choice. I try to create it normally by providing a password, including local...
asked by 05.11.2017 / 10:40
2
answers

I can not connect to my Docker database from pgAdmin 4

With the command "docker-machine ip" I get the ip and I enter it in the "Host name / adreess" field. I get the following error. This is the port of the database.     
asked by 06.11.2017 / 18:35
0
answers

What do I do with "provider can not be found. it may not be properly installed "?

I have this problem with the RAD studio 10.2 when executing a program that shows the data of a table in a grid ... (yes, very basic). Work with pgAdmin 4 I do not know if this helps, since I was reading that the problem is with the...
asked by 28.10.2017 / 18:34