Questions tagged as 'postgresql'

Tagged questions
0
answers

Field byte type in postgresql show it in a Laravel view

Good afternoon I have been working with Laravel 5.6 and I must pass an image that is inserted in a postgresql 10 database as a byte field type made embedded php code in view to be able to pull the data and present it but I did not succeed this i...
asked by 26.10.2018 / 16:25
1
answer

Do not insert data. from the input between django and postgres

catalog / urls.py from django.urls import path from catalogos.views import CategoriaView,CategoriaNew urlpatterns =[ ..... path('categorias/new', CategoriaNew.as_view(),name='categoria_new'), ] views.py class CategoriaNew(g...
asked by 30.10.2018 / 18:17
0
answers

How to execute a stored procedure with jdbc, dao in java, primefaces and jsf

I have a problem when setting the data of a stored procedure to a datatable, what happens is that I am working with jsf, primefaces, jdbc, create a java class that would be this: package avo.ob.movie; import java.sql.Connection; import java.s...
asked by 22.10.2018 / 22:39
1
answer

Images in databases and Laravel 5.6

Good evening I have been working with Laravel 5.6, and they gave me the task of making a query to the database that is postgresql and showing the result in a view. The problem is that in the data consulted there is a field where images are store...
asked by 18.10.2018 / 02:24
0
answers

InvocationTargetException when creating a session in Hibernate

I'm learning to use hibernate, and I do not know if it's bad luck but every tutorial I find and implement ends up giving me exceptions, even if they are official tutorials. My problem is that when creating a session and saving an object of ty...
asked by 17.10.2018 / 16:34
1
answer

When I make a query within a function to assign the result to a variable, if the query does not return anything, does it save a null value?

SELECT c.horas_aportadas INTO horas_aportadas_coordinador FROM voluntario c WHERE new.id_coordinador = c.nro_voluntario; In that code, the id_coordinador is an attribute that can be null, so if it is then the query does not return anyth...
asked by 20.10.2018 / 19:11
0
answers

PostgreSQL: Is there a difference between timestamp (0) without time zone and timestamp without time zone?

I am using postgresql and Laravel, when doing migrations the date fields send them to me as timestamp(0) without time zone , but in the data type of postgre when a new column is going to be created I find them so timestamp without time...
asked by 09.10.2018 / 22:17
0
answers

Query with SP to locate 100000 records from one table to another in postgres

I have a query, I have a problem where I have a table package and another bins, where package has 100000 (the structure is described below) in this table there is a field called wheitgh which has an int random value from 0 to a maximum of 100 an...
asked by 13.10.2018 / 08:48
1
answer

Import data from csv file

I have a csv file which has this data that takes them out of a single field. As you will see, it is not only data from a single field. In the table where I want to insert this data has the following structure. The information I...
asked by 15.10.2018 / 16:56
0
answers

Error install PostgreSQL 64 and 32 its

I have an error when installing Postgresql, I am installing version 10.5.2 for both 64 and 32 bits. When I run the installer, it tells me that it needs to install: It keeps loading and sends me error. If I search separately to download it,...
asked by 02.10.2018 / 18:17