Questions tagged as 'postgresql'

1
answer

The filter does not work for selects in datatables

I am using the "datatables" plugin in a server-side way, it works perfectly but if I add the "select inputs" it does not work for me, just that option. I got the code from the following link: API link Here is the Ajax code: var tabl...
asked by 14.12.2016 / 02:05
1
answer

Help with a $ scope and data from a database on google maps

I have a problem and I do not know how to use a scope variable and show it on the map, it does not recognize the location /** * Created by gamba on 20/10/2016. */ var app = angular.module("mapas",[]); app.controller("myctrl",func...
asked by 07.12.2016 / 00:49
1
answer

How to recover part of compound data with JDBC?

I have a small application that connects with postgresql , it stores 2 objects, Equipment that has three values: store type String , range type String and finally price type int . To store them, I occupy a type co...
asked by 28.10.2016 / 13:29
1
answer

PgAdmin freezes when trying to delete a table from the database

I have problems with a table in my database which was linked to geoserver. The layer was removed from geoserver but the table is still in the database. When you try to delete it with DROP TABLE, the program freezes, in fact just by touching the...
asked by 16.09.2016 / 17:05
1
answer

database query duplicates me the same when joining other tables

I am consulting several tables, the main table t_persona has 441,153 records and the table t_evaluación has 471,558. The evaluation table can have several times the code of the person since a person can have 1 or more evaluations....
asked by 17.10.2018 / 21:59
1
answer

postgres in windows 8, zip installation, does not allow to boot, privileges

I have downloaded the PostgreSQL version: link When I unzip and start Windows, I get this message. What could it be? Problems booting     
asked by 06.09.2018 / 03:37
1
answer

Error "The application server could not be contacted" pgAdmin 4

I have installed PostgreSQL 10.5 and pgadmin 4 version 3.2 but when I try to start the pg admin 4 this error appears:    "The application server could not be contacted".     
asked by 02.09.2018 / 22:43
2
answers

I can not insert content with special characters to database

I am working on importing an Excel with the PHPExcel library with PHP in codeigniter. It has characters like " " , not allowing the insertion to my database with Postgres. This is my function within the model that inserts the records:...
asked by 02.12.2017 / 00:57
1
answer

How do I create N cant of columns in an sql query? in postgresql

In the current query I have static to 2 columns, but I would like to create columns for each shift that is in another table. Here the 2 fiddle of what I have: sqlfiddle and dbfiddle Update 1 (trying to specify a little more): T...
asked by 18.03.2017 / 18:39
1
answer

Create Postgres 9.3 connection with Python 3.6

I am starting to program in Python . My first problem is this: I can not connect to the bd of postgres . The library psycopg2 is not detected by the program pycharm I downloaded this program, which has been installed...
asked by 24.12.2018 / 20:30