Questions tagged as 'postgresql'

Tagged questions
1
answer

tenant application for multiple users

Good my doubt and as long as the approach of creating a database in the following scenarios Multiple Database, a database created by user Multiple Schemas, well it would only have a single database, but each user would have their schema...
asked by 24.10.2017 / 04:08
1
answer

Save image in the POSTGRES database with DELPHI Tokyo by the Android App

I need to save a photo that is taken to the tablet's camera and save it to the database. Type the field the 'typea'. I'm using the Timage component to view and reference the image, but I can not save it in the database. Thank you.     
asked by 29.09.2017 / 23:48
1
answer

Save User Location

I'm trying to save the user's location in a database, to later generate user reports by country, state, and region. I initially downloaded databases that contained the names of all cities in the world, in multiple languages, but this left the...
asked by 02.09.2017 / 15:33
2
answers

Problem with dates in PostgreSQL

I have this query below and I want the faturamento , ticket_medio and qtd_pecas , qtd_atendimentos , to be divided by the numbers on Tuesdays. Example had 5 Tuesdays with values registered in this view, I want it to be d...
asked by 10.08.2017 / 17:40
0
answers

Help tool in Postgresql configuration. conf

Does anyone know of any tool that helps in setting the parameters of the file postgresql.conf. I've already made use of PGTUNE and PGConfig , but they do not indicate anything of the parameters: cpu_tuple_cost cpu_index_tuple_cost...
asked by 25.08.2017 / 20:24
0
answers

Java / Postgresql - Function does not return values

I am creating a webservice where I will return the values from my postgresql table. However, when I perform this function, a blank screen appears as if there were no data to be returned. I purposely failed to connect the connection data as drive...
asked by 27.07.2017 / 21:28
2
answers

Filter in WHERE Postgresql

Good morning folks, next, I'm doing a standardization of some records here in the company. So there are 2 tables. Table A (old records) columns as: id_alvara | logradouro 1 | Rua Sete de Setembro n° 200 2 | Rua tal 300 3...
asked by 06.07.2017 / 15:11
1
answer

Query using order by with slowness

I have a query like this: select ae_id from app_event join trip_item on ti_id = ae_trip_item_id where ae_driver_id = 63 order by ae_date desc limit 10; The app_event table has about 3miles of data, and the trip_item table has...
asked by 28.06.2017 / 14:42
0
answers

Transaction with Entitiframework 6.1.3 and PostgresSql does not work correctly

I'm trying to use EntityFramework6.Npgsqlcom transaction, however I get an exception when I call the DbContext.UseTransaction method and step a transaction. Error message (Last InnerException):    "Npgsql.PostgresException (0x80004005):...
asked by 21.05.2017 / 17:50
1
answer

Table names in Hibernate are created with lowercase letters

I'm trying to transform the following Entity into a table in Postgre using Hibernate @Entity @Table(name="Usuarios") public class Usuario implements Serializable { ... } The problem is that when the table is created, its name is created wit...
asked by 06.06.2017 / 15:07