Questions tagged as 'postgresql'

Tagged questions
1
answer

Search without reloading the page [duplicate]

I need to perform a Facebook search, that is to say, by typing the name X in an input that is filtered from a database query without reloading the page How should I do it I'm working with java and postgresql database     
asked by 13.10.2016 / 05:08
0
answers

Amazon AWS Install PostgreSQL on my EC2 or create separate RDS service? [closed]

I currently have a Web Service and a Database in PosgreSQL which I need to be in the cloud, I have an EC2 instance where I have tomcat installed, I want to know that they patch me, have the database in the EC2 instacia or get the RDS service and...
asked by 14.08.2016 / 04:45
0
answers

migrate sqlserver database to postgresql [closed]

Will someone have a program to migrate from sqlserver to postgresql? I have recently used the ESF Database Migration Toolkit but unfortunately it is paid and the demo modifies the fields of the database with a "T" at the beginning of each record...
asked by 09.07.2016 / 18:33
0
answers

Doubt with output format pgAdmin III

my question is this: There is some way that when generating a query in postgreSql the first row comes out with the following ================, as the following example shows: campo1 campo2 campo3 campo4 1 ===========================...
asked by 27.05.2016 / 05:52
1
answer

Revoke a specific query in PostgreSQL

Well the question is this, A User may indicate in a query the name of the patients who DO NOT have an associated card, but another user will not be able to make THIS query. Can you revoke that permission? because the easiest thing would be...
asked by 10.04.2016 / 06:49
1
answer

Postgres-Netbeans

Hello a few days ago I asked a question in which I asked for help to know how it could generate the connection between postgres and netbeans .... In one of your answers they recommended tutorialspoint .... It is worth mentioning that the applica...
asked by 09.04.2016 / 05:05
1
answer

Postgres: Get what part is a record within a set

Good morning, I am trying to obtain or calculate the information of each record within a set (quota and partial value), I explain it below with an example: | id_pago | fecha | valor | |:-----------|------------:|:-----:| | 910006603...
asked by 24.04.2017 / 17:37
1
answer

Problems counting in a Query

The structure of the tables is as follows: child CREATE TABLE CHILD( child_id SMALLINT, child_name VARCHAR(255) NOT NULL, birth_date DATE NOT NULL, gender VARCHAR(255) NOT NULL, address VARCHAR(255), city VARCHAR(255), CONSTRAINT PK_CHILD...
asked by 31.10.2017 / 09:42
2
answers

Query by date range with many nested queries

I have to obtain a list with the clients of the company to which we have invoiced something during the current year, indicating how much we have invoiced each month. I have two tables: the customer table (customer) and the invoice table (invo...
asked by 12.12.2017 / 11:43
1
answer

Query per month in PostgreSQL [closed]

Good day to the community, my question is how I can make a query to a specific table based on the current month, I want to get the record of the first day until the last day of the month, no matter what day of the current month we let's find, I'...
asked by 20.08.2018 / 18:29