Questions tagged as 'postgresql'

2
answers

Error trying to connect to a PostgreSQL database with Hibernate and Spring Boot

I am a beginner in Spring Boot and Hibernate, I did a project in the Spring Initializr with only the dependencies Web, DevTools e PostgreSQL , but then I added the dependency spring-boot-starter-data-jpa , I was following some tuto...
asked by 19.09.2018 / 03:12
1
answer

How to create a named Primary Key constraint in Postgres?

I'm continuing to create a primary keyless table initially. Then I add a id field of serial type and try to create the constraint for the Primary Key (PK): create table macaco( nome varchar(50), idade integer ); --adicionando o id do...
asked by 16.08.2018 / 17:22
0
answers

Problem with rails command db: create undefined symbol: rb_enc_alias

When I create a project (from scratch) I then give the comado rails db: create to create the database and I get this error: LoadError: /var/lib/gems/2.3.0/gems/pg-1.1.0/lib/pg_ext.so: undefined symbol: rb_enc_alias - /var/lib/gems/2.3.0/gems/...
asked by 27.08.2018 / 23:00
2
answers

Doubt when creating table with dates in postgresql

I have the following table structure: Iwouldneedtocreatea3rdtablethatwouldlooklikethis: I have the smallest and longest date in a table and in another table I have changes made, I would need to create a script that would generate a 3rd...
asked by 06.07.2018 / 00:09
0
answers

Connect to the Database in Azure Functions (Javascript)

Alright? I have faced a constant problem, and I do not know what to try to resolve it. I created an Azure Function and need to query some data in the database, in order to return them as a function response. I created a PostgreSQL Datab...
asked by 28.08.2018 / 21:34
0
answers

Remote connection with PostgreSQL only works after PING

I have a JAVA application running on one server and the database running on another. Both servers are connected and on the same network, postgreSQL is enabled to receive external connections. But when I try to connect to the database from...
asked by 03.07.2018 / 22:04
1
answer

LEFT OUTER JOIN

I have a table in PostgreSQL. I would like to count two columns where one has more record than the other. If I use LEFT OUTER JOIN I think it will work, though, I'm not getting with the PostgreSQL syntax. The command I am using is as follows:...
asked by 15.06.2018 / 16:48
1
answer

Add values in a Select (postgres)

I'm having a little problem, I need to populate a gridview in C #, but my query is not doing the sum of some values and this is causing the company code to be repeated and with the value "separated" p> The value I need is the sum of the 3 valu...
asked by 07.06.2018 / 20:06
1
answer

Connect MS SQL to PGADMIN

Hello, good afternoon! I need to know if there are any tools, scripts or anything else where I can have the following scenario: I have an MS SQL database however I need to manipulate it through pgAdmin (postgres). Cnosegui do the invers...
asked by 15.05.2018 / 21:33
1
answer

Map relationship between tables without foreign key

I have two tables in postgresql: schema1.imovel idt_imovel | int cod_imovel | string nome_imovel | string etc... schema2.declaration idt_declaracao | int cod_imovel | string status | string etc... The two tabl...
asked by 27.04.2018 / 14:20