Questions tagged as 'postgresql'

Tagged questions
0
answers

query codeigniter postgres

I have a problem with codeigniter and postgresql, my database has around 230,000 records, and I'm doing a report which points to a view that is made up of 4 tables, The problem starts when I ask a query to that view on short dates for example...
asked by 27.02.2018 / 14:46
1
answer

postgresql - how to send a table parameter in a function?

I am using postgresql, I would like to know how to send a table parameter in a function. I have already created the type type_detalle_ac: CREATE TYPE public.type_detalle_ac AS ( id_componente integer, precio numeric(10,2), cantidad integer,...
asked by 02.03.2018 / 16:45
1
answer

Validate a field of type Float accept zeros after a decimal point in SQLAlchemy

I am using the Sqlalchemy orm, when I enter a data of type Float or Numeric does not accept zeros, example: price = 12.0231 price = 12.1021 price = 12.0012 The previous ones, if you keep the zeros The problem is when the z...
asked by 25.02.2018 / 02:17
3
answers

How to optimize sql query?

I happen to have a table with n records ... 20 for example ... Of those 20, 5 records belong to 4 people, that is to say that there are 4 people who were registered 5 times in that table, for a total of 20 (by way of example) ... The query that...
asked by 22.02.2018 / 16:28
0
answers

Error when inserting data into a table in PostgreSQL with Java Netbeans 8.2

I have a table with the fields: sales_id, date, name and address; of which the name and address are placed on the website, to register the sale, the user enters his name and address and at the time of sending the code must assign an id_venta and...
asked by 19.02.2018 / 14:41
1
answer

How to load a mysql table with php?

Good morning, I'm new to php, I need to load a complete table that is in my mysql database and show it as a table with its header and everything on my website, if you could help me, thanks?     
asked by 19.02.2018 / 16:34
1
answer

error when creating a database in postgresql

good teammates what happens is that I will do the practices in PostgreSQL and I get the following error, some postgresql expert can help me with that problem, please ...     
asked by 07.02.2018 / 23:20
1
answer

datatables with php, jquery and postgresql

Good day, I have been working without any problem with datatables, php and mysql, but when trying to use the plugin with Postgresql it has not worked, I do not know if it requires any additional configuration. in advance I appreciate any help or...
asked by 08.02.2018 / 23:59
0
answers

CrystalReport error in ASP and PostgreSql in Windows server 2012

I am developing a web application that has to show a report with CrystalRepor v. 13.0.2000.0 (devoloper version for visual studio 2015). This report in development environment with Windows 7 64bits works perfectly and generates the PDF from the...
asked by 08.02.2018 / 12:21
0
answers

Java hibernate: Error with Hibernate console configuration

I am trying to configure a project implementing Hibernate with postgresSql. When I try to configure Hibernate console configuration I get the following error and I can not continue: Does anyone know why it can be ?? Greetings and thanks...
asked by 28.01.2018 / 21:16