Questions tagged as 'postgresql'

Tagged questions
1
answer

Generate relationships in pgAdmin 4 (Postgresql)?

I am maintaining a database in Postgresql , being sincere it is very complex and I can not understand it completely. I have searched for information to be able to generate relationships between the tables, and thus better understand the da...
asked by 13.12.2017 / 21:05
1
answer

Move from rows to columns in Postgresql

I have a table very similar to this one (the id is not a primary key): id nombre producto atributo 1 Camiseta Color: Negro 1 Camiseta Tam: XL I would like to know how I can move from the previou...
asked by 14.11.2017 / 20:27
2
answers

Error in postgresql

I have a question about postgresql that does not allow me to move forward and maybe it's something simple that I'm forgetting or omitting. This is the structure of my table: CREATE TABLE public.p_proyecto ( id_proyecto INTEGER NOT NULL...
asked by 14.11.2017 / 14:30
1
answer

PostgreSQL connector with C # [closed]

I would like to know which is the best connector to link C # with Free Postgres, of course, because it does not name a good payment that is not very expensive. Thanks     
asked by 01.09.2017 / 03:22
2
answers

Problem with complex PostgreSQL query

Please, I need help with a query in PostgreSQL The query is as follows: SELECT DISTINCT("ventas"."Product Category") AS "Categoria de Producto", (EXTRACT(MONTH FROM "ventas"."Order Date")) AS "Mes", "ventas"."region" AS "Región", "ventas"."...
asked by 03.11.2017 / 08:52
1
answer

Postgresql doubt field number

Good I need to enter high values for example 65.000.00 for the price of a product I have a Price field defined as Numeric (18.2) But it only allows me to enter values less than or equal to 999.00 as I would in this case?     
asked by 02.07.2017 / 23:04
2
answers

Send console values by REST API

I have a project in Spring Boot that connects to Postgresql and sends the values by console , what I'm looking for is to be able to send it through JSON in a REST query, but I do not know which part to change the project. That's what I'm lookin...
asked by 09.08.2017 / 21:23
1
answer

the BD table in postgresql is not updated

Good morning, I am practicing with PHP and postgresql to do a project for the university and I have not been able to update a table in the BD for two days. I've been changing the syntax reading solutions in different forums and I do not know wha...
asked by 28.05.2017 / 10:22
2
answers

Show null or default value when bringing a query without results

I would like to be able to bring a default value after executing a query in case it does not bring any rows. I have tried a bit of everything, COALESCE, NULLIF, NOT EXISTS, EXISTS, etc. I do not know if someone has already tried it before to...
asked by 01.06.2017 / 15:49
2
answers

Create a database model that shows a user's friends

Good evening I have a problem, I am creating a database which uses users who in turn have friends, I can show the relationship between users and their friends but I can not show the names of the friends (I can only show ID) Users table: CRE...
asked by 09.05.2017 / 02:39