Questions tagged as 'postgresql'

Tagged questions
2
answers

NEW and OLD variables postgres

I have the following problem, I need to make a bitacora and that for each modified data create a record in the bd. Each table has a trigger that will call the bitacora function () and inside it I must capture the OLD and NEW and cycle so that...
asked by 06.10.2017 / 19:31
1
answer

How to save an image in Database by URL

I have a database in Postgresql and using pgadmin4, there I have a table called products with 5 columns that contain the following types of data: Id, name, description, price, type. Now I want to add a column where I can save an image from its u...
asked by 15.09.2017 / 22:15
2
answers

PostgreSQL - ERROR: the "codpais" column does not exist SQL state: 42703

Hello Any help to correct this problem in PostgreSQL 9.6 I have a query made by the graphic assistant, which shows the automatic code: SELECT * FROM public.pais ORDER BY "CodPais" ASC The previous code shows the results of the country t...
asked by 08.09.2017 / 02:14
1
answer

psycopg2.OperationalError: fe_sendauth: no password supplied⁠?

It turns out that I'm trying to get my program to get data from a database generated from pgadmin, but I'm not making it happen. I'm trying to make this work: from psycopg2 import connect import dbconfig cfg=dbconfig dbname=cfg.dbname dbhos...
asked by 07.07.2017 / 22:01
1
answer

laravel filter results by date range

Hi, I need to filter according to a particular range of dates. I'm trying to do it on my own but it has not gone well. It is giving me this error. I want to filter by the field Date_emission below is the model of my table "SQLSTATE[22007]: Inv...
asked by 07.06.2017 / 17:37
2
answers

backup postgresql from java

I have a code implemented for backup but when it runs it does not do anything to me and it does not give any errors. I have searched the Internet for other ways to do it but all the examples are similar to the code I use (besides I tried them an...
asked by 19.04.2017 / 22:20
1
answer

Substitute value within a query in postgresql

Good day. I have the following query: COPY (SELECT "UR_16PIX_Chih"."ID_UR", "UR_16PIX_Chih"."IDEDOMUN15", "UR_16PIX_Chih"."PIX1", "UR_16PIX_Chih"."PIX2", "UR_16PIX_Chih"."PIX3", "UR_16PIX_Chih"."PIX4", "UR_16PIX_Chih"."PIX5", "UR_16PIX...
asked by 17.04.2017 / 06:25
1
answer

Problem when granting permissions in DB-PostgreSQL

good day. I am having problems granting all permissions to a user on a database that I am creating. Use PostgreSQL 9.6. First I create my user in this way: CREATE USER springappuser WITH PASSWORD 'pspringappuser'; The database...
asked by 25.03.2017 / 01:42
1
answer

Generate Postgres output in columns

I am trying to make a query in a Postgres database where I want to get results in the form of a table as follows. Variables 1, 2 ... n are the names of the sensors that are known (from the list in the query). Then, the result would be for each d...
asked by 07.03.2017 / 09:29
1
answer

VB.NET receives no response from PostgreSQL 9.3 when inserting duplicate record

I have migrated from PostgreSQL 8.3 to PostgreSQL 9.3 to be able to use the improvements implemented in this version. With version 8.2 I had no problem controlling errors when trying to insert a duplicate record with a unique key since the progr...
asked by 28.02.2017 / 09:23