Questions tagged as 'postgresql'

Tagged questions
0
answers

Special characters PostgreSQL

Hello! I have the following problem, in a PostgreSQL database migration, many registry was thus "C�mara Municipal de S�o Pedro" , an update via php resolves more are many records, I wanted to convert it this way: update cad_cliente set n...
asked by 07.02.2018 / 16:21
0
answers

Triiger log on Postgree

Does anyone know if I can create a trigger logon in Postgree? I have not found this information anywhere and need to create it only for system and bank logins, to collect source host, logon time and logout.     
asked by 05.02.2018 / 19:59
0
answers

How to create method to start a report - java

How do I create a method for starting a DB report? Follow my method below. public void printReport (Date initialDate, Date endDate){ list<Sale> sales = getSales (initialDate, endDate); for (Sale s:sales){ S...
asked by 29.01.2018 / 13:03
1
answer

Create query to return the lowest possible value

Good evening. I need to do a sales report grouped by period and by card. But I do not know how I can enter a store and horizontally it appears the values of each card. Example of what the output should look like: Loja01, with 03 sales (100 visa,...
asked by 05.02.2018 / 23:49
1
answer

Very crazy error in registry PostgreSQL X FastReport

I have several tables that make MasterDetail with each other, I will not put the structure here because it is very complex, there are 26 tables involved. The error is as follows: a table has a record that when opened by FastReport it simply g...
asked by 22.01.2018 / 14:01
1
answer

Settings environment timezones django postgres linux

Good morning, everyone. I have a site (Django) on a linux hosting service with Postgre SQL bank that is in New Jersey (USA). Users are in Brazil, so I have a timezone difference. I'm pretty sure this is a silly thing, with an adjustment I...
asked by 16.01.2018 / 14:09
0
answers

How to filter a datagrid in vb net using a textbox

How to filter a datagridview using a textbox (Field "Receipt")? The code below fills the datagridview with the data in the box Sub CaixaLoad() Dim c As New Caixa() Dim ds As New DataSet Try ds = c.buscaLancamento()...
asked by 14.01.2018 / 16:17
2
answers

Postgresql, Variables for psql functions

I'm trying to create a trigger function to remove a schema created in the database based on an idproj attribute of the geo.projects table listed below: CREATE TABLE geo.projetos ( idproj serial NOT NULL, ... , -- outros atributos...
asked by 11.01.2018 / 20:35
1
answer

wrong map projection

I am trying to insert dots into a layer using leaflet and save those points in a Postgres (Postgis) database. With the geoserver I can see the layer but the points appear to me all wrong and I know that this has to do with the projection but I a...
asked by 10.01.2018 / 19:03
0
answers

Create Parameter in XML (Get id by URL through XML parameter)

I have an XML-SCHEMA cube (sql query) in an XML file which is the file type to open in the Pentaho workbench. I would like to know if you have to pass a parameter in XML so when this file is in the web it picks the id of the URL by the parameter...
asked by 16.01.2018 / 21:23