Questions tagged as 'postgresql'

Tagged questions
2
answers

How to dynamically get a specific day in a query

I would like to get the last day of the previous month in a dynamic way. I do not know how it is that I will by wo.createdtime <= Moth(current_date) something like that and this is in milliseconds, it complicates even more. If anyone c...
asked by 10.07.2018 / 21:58
1
answer

How to check if a connection is "sleeping" in php?

I have the following script: $fp = @fsockopen($IPAddress, $newport, $errno, $errstr, (float) 0.5); if ($fp) { echo("Conectado\n"); } else { echo("Desconectado\n"); } This script checks if a particular port is open, works fine. I...
asked by 06.09.2018 / 20:04
2
answers

Return Value ID C # NpgsqlCommand

After inserting a line of information into a given table, I need to retrieve the ID value to fill my object, my code looks like this: using (NpgsqlConnection pgsqlConnection = new NpgsqlConnection(conn) { pgsqlCo...
asked by 06.09.2018 / 23:38
1
answer

Check the names of the pilots sponsored by a Team

I want to consult pilots sponsored by team 'A' I'm doing this: SELECT piloto.nome AS NomePiloto FROM equipe INNER JOIN piloto ON equipe.idequipe = piloto.idequipe INNER JOIN patrocinador ON patrocinador.idpat = equipe.idpat WHERE patrocinad...
asked by 07.09.2018 / 05:56
1
answer

Error when trying to backup database in postgresql

I'm trying to back up a database in Postgresql, however I'm getting the following error: erro ao ler objeto grande 118287: ERROR: permission denied for large object 118287 I looked up the error and found the following information...
asked by 09.07.2018 / 14:01
1
answer

How to update column for each SELECT in a given table?

I tried to create a trigger for a table using it so that it would be activated after every select , but by searching a little I discovered that it is not possible to create triggers for selections, only for update, insert ) a...
asked by 13.06.2018 / 18:49
1
answer

How to generate my PostgreSQL BaseURL (link) that is in Heroku to integrate with my Angular front end?

My question is: how do I generate the link (baseurl) so that my front-end accesses the data coming from that database (PostgreSQL) > Heroku ? My PostgreSQL there from Heroku releases this information: As img above I have host ,...
asked by 09.05.2018 / 14:53
1
answer

Error url $ feed-id

Hello, I'm working on a system with feed scheme. Clicking "Edit" displays the following error:    SQLSTATE [22P02]: Invalid text representation: 7 ERROR: invalid input   syntax for integer: "$ feed- > id" (SQL: select * from "feeds" where...
asked by 19.04.2018 / 20:27
2
answers

How to disable Trigger of all tables in PostgreSQL? [closed]

How to disable the triggering of all my tables in postgreSQL?     
asked by 20.04.2018 / 03:55
1
answer

How to return a table from a POSTGRES function?

Hello, I'm trying to create a function in postgres, which at first is all correct, taking the return from the function. When I run the function, it is returning all rows, but all in only one field as a string. And I need it to come in the tab...
asked by 20.03.2018 / 19:53