Questions tagged as 'postgresql'

2
answers

SQL query that compares two tables and returns values

Working with a database using PostgreSQL DBMS, where I need to compare tables, eg: table_janeiro and table_February. I need to perform two queries ... 1st Should return the values contained in the table_janeiro and do not contain in th...
asked by 07.03.2018 / 20:08
2
answers

How to add a unique constraint on a column without deleting the table or column

This is the sample table create table usuario( id serial primary key not null, nome varchar(100), email varchar(100), login varchar(100), senha varchar(100), tipo varchar(50), status varchar(30) ) I used this cod...
asked by 01.03.2018 / 03:43
0
answers

How to run PostgreSQL on my site

I have a site that is in the server hostgator my bank and PostgreSQL and in the c panel only have mysql they said that to run PostgreSQL I need the vps server inside it under PostgreSQL and I do the integration of the bank with my site! What...
asked by 27.02.2018 / 16:44
1
answer

Problems with "libpq.so.5": wrong ELF class: ELFCLASS64 in C

I'm trying to run a compiled file in c and I get the following error message: "error while loading shared libraries: libpq.so.5: wrong ELF class: ELFCLASS64" I did a search and I identified that this type of error is due to the x64 and x86...
asked by 28.02.2018 / 15:27
0
answers

How to optimize Java connection with Postgres

My connection class to the database is taking a long time to open the connection, it takes almost 20 seconds. I use Hibernate and the Bank is Postgres running localhost. Am I doing something wrong? or to optimize and open faster? My class:...
asked by 28.02.2018 / 15:39
1
answer

Java.Lang.NullPoinerException when trying to insert database data into a JComboBox [duplicate]

Today my team and I encountered a problem when trying to do something seemingly simple: display the surname of an official in a JComboBox. The problem is that at the time of opening the screen we receive a NullPointerException and the Combo is...
asked by 23.02.2018 / 20:27
3
answers

Return DB data using List / ArrayList - Java

I'm having a problem, I set up a PivotTable in PostgreSQL and I need to print the lines of it, doing a Java method, the start of which is already established. That would be with a simple% w / o having as a parameter the start and end dates. H...
asked by 08.02.2018 / 19:02
1
answer

Update method does not update in the database

I have a problem at the time of editing, when I click on the button it looks for the information of the fields in the console.log, already has the ID in the route also the problem is that it does not update the information in the bank, p> expor...
asked by 22.02.2018 / 14:21
1
answer

NullPointer Exception when inserting data into a key Estressira [closed]

I'm experiencing some problems with inserting data into my Customers table. Specifically with foreign keys fk_telefone_fisico and fk_telefone_juridico . When I register the user and it gives me a NullPointerException , but...
asked by 15.02.2018 / 13:18
0
answers

How to use postgresql

I see the only hosting sites with mysql and to use postgresql only by VPS, can someone explain me this better? How do I integrate my postgre bank on my site with VPS? Why do you have to have VPS? to do this and good for my site? type mysql ja ta...
asked by 15.02.2018 / 21:29