Questions tagged as 'postgresql'

Tagged questions
1
answer

How to select double contacts from a table

I have 2 tables: Users [id, name, etc ...] Friends [id, idUser, idImigo] In the Friends table, idUser corresponds to the id of the user who has the contact and idAmigo the id of the user who is actually the contact. I wanted to d...
asked by 12.02.2017 / 01:35
1
answer

Creating Function PostgreSQL

I have a problem creating a function . I'm pulling its parameters from my java application, the problem occurs when pulling the parameters ( variavel1 , and variavel2 ) because they are coming from the application as text. An error...
asked by 12.12.2016 / 17:40
1
answer

Connect with PostGreSQL

I have a *.ini file that connects to my Firebird database, however I need this file now to be configured to connect to PostGreSQL [IBConnection] DriverName=Interbase Database=192.168.1.30:C:\testes\impressoes.fdb Role...
asked by 07.10.2016 / 20:43
2
answers

Problem with connection between EF and PostgreSQL

I'm trying to make a connection to EF and PostgreSQL in an Asp.Net Mvc application I'm using the following references EntityFramework6.Npgsql Npgsql 3.1 .NET Framework 4.5 I have the following classes: public class Categoria {...
asked by 18.02.2017 / 18:48
1
answer

where for inner join

As I have three WHERE tables select login, nome_hotel from extranet_login, extranet_hoteis, hoteis where extranet_login.id_login=extranet_hoteis.id_login and extranet_hoteis.id_hotel=hoteis.id_hotel and extranet_login.login='admin'; for...
asked by 09.06.2016 / 11:06
2
answers

Inserting Single Quotes Null Field

I created a very simple application to simulate a small register of clients, but when testing the data manipulation by the application I could see in the database that the fields that are null in the register are inserted into the database with...
asked by 28.04.2016 / 23:04
4
answers

PostgreSQL - Remove tuple referenced by another table

I have a problem that I did not find anything on Google (maybe I did not know how to ask him) Imagine the following: I have 11 tables, one call tbl_pai and 10 other calls tbl_filha1 , tbl_filha2 , tbl_fila / em>. / li>...
asked by 27.01.2016 / 14:05
1
answer

Structure PostgreSQL 9.3 CentOS

I would like to know what is and what is part of this base directory.    /var/lib/pgsql/9.3/data/base/17500/18037       /var/lib/pgsql/9.3/data/base/17500/18170       /var/lib/pgsql/9.3/data/base/17500/18168       /var/lib/pgsql/9.3/data...
asked by 29.01.2015 / 15:24
2
answers

Help with parameters TextBox / string

I have this method where I would like to bring IBGE. When I put the TextBox as a parameter, it usually comes up, but the problem is that I am using a Library and can not import the TextBox. So I replace the TextBox with a string, but that way it...
asked by 29.07.2015 / 13:19
1
answer

java.lang.NullPointerException Error in JDBC Connection with WS + Postgres

I'm creating a WS that connects to a PostgreSQL DB and performs a query on a single table. I try to run it locally, but the problem is when I run the application it gives the following error:    HTTP 500 Status - Internal Server Error   ...
asked by 04.09.2014 / 16:40