Questions tagged as 'postgresql'

Tagged questions
3
answers

Delete Report with months reset

I have a query in which I take monthly deposited values, it takes everything that it has in the base and shows the months that were inserted in the database. I would like to do different would like it to also show the months that did not have...
asked by 08.11.2016 / 16:19
1
answer

Select accessing two tables

I have a Product table, with the marker, model, and type fields. A second table for laptops has its fields related to price, RAM, other fields, and the model, which is the same as the Product table. How to make a select that tells me the m...
asked by 01.09.2016 / 21:15
1
answer

Notification on a local network with PostgreSQL

I would like to know how I can send a simple notification to users on a local network, send a notification to all other devices with the app connected to the PostgreSQL database ...     
asked by 13.09.2016 / 23:45
1
answer

Postgress Transaction in NodeJs

I want to encapsulate my SQL execution in the Postgress database. My initial desire is to call a method to execute a specific query and another method to execute a multi-query transaction. exports.executaSQL = function (select, listaParametros...
asked by 25.09.2016 / 21:21
1
answer

SELECT in postgresql does not take records in the time interval

I have the following SELECT SELECT * FROM motoqueiros WHERE now() - INTERVAL '8 SECONDS' <= data_update It works on my local machine. I created a server in AMAZON, the server has ubuntu 14 64 bits, when I execute the same select it does...
asked by 10.08.2016 / 15:01
1
answer

Comparison with data recorded as JSON

I have a date field that is written to the field in JSON format, along with other values {"data_limite":"14\/07\/2016","data_programada":null,"admin_agendamento":"4813"} This "deadline" field, I need on another screen to put in a CASE-WHEN...
asked by 11.07.2016 / 15:51
1
answer

How to join 4 tables in SQL that is returning empty? (Inner, outer, or left join)

I have 4 tables with the following relationships: Products have N Variations Sizes have N Variations Colors have N Variations Variations belongs to Products, Sizes and Colors The structure of the tables looks like this: Variatio...
asked by 02.06.2016 / 19:21
2
answers

Login in Postgresql and PHP

Good people, I'm a beginner in programming and I'm learning in PostgreSQL since I know how to work in mysql and a little in PHP . I'm creating the login form with PostgreSQL and PHP and I'm a little clumsy....
asked by 03.06.2016 / 13:31
1
answer

How to convert certain group of columns to JSON?

I have the following problem: I have a table with N columns, but I would like to make almost all of them into a single column of type json, eg: id, json(col2,col3,col4) as dados I looked at the documentation, and found a command that...
asked by 26.03.2016 / 01:45
2
answers

Python 3.5 + Django + PostgreSQL on Windows

I'm currently starting a web system project using Python 3.5 and the Django 1.9.1 framework, with the intention of integrating them with a database PostgreSQL 9.5 , all installed on a machine running Windows 10 x64 OS. The installation of Py...
asked by 02.03.2016 / 23:34