Questions tagged as 'postgresql'

Tagged questions
1
answer

Android studio connectivity with postgresql

I followed a tutorial to connect PostgresSql with Android, but still I have not obtained any solution. How do I connect Android Studio with PostgreSsql? I have written this code in my MainActitvity.java. static final String JDBC_D...
asked by 18.09.2017 / 11:16
1
answer

alter table mysql in postgresql

I'm trying to make this modification from MySQL to postgresql: ALTER TABLE documento_autor ADD CONSTRAINT FOREIGN KEY(id_autor) REFERENCES autores (id_autor) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE documento_autor ADD CONSTRAINT FORE...
asked by 07.09.2017 / 19:36
0
answers

capture warning messages postgresql from python - sqlalchemy

Please can someone guide me as I can capture the personalized WARNING-level messages created in POSTGRES, I explain. I have currently created a function that returns general box information, there is a calculated field in which if this is les...
asked by 11.08.2017 / 05:38
1
answer

Get content that was produced there is less than one time with SQL on PostgreSQL

I want to recover for the content that was produced there is less than 30 days: -- veces una personna deu groupo interragi con contenido, SELECT COUNT (swipe.state),swipe.eclipse_id FROM swipe WHERE (swipe.state= 2...
asked by 02.08.2017 / 17:56
2
answers

How to update postgres database structure without altering its records?

What I need at this moment is a way to update the structure of the database without altering its records, I have a database that has not been touched for a long time according to the versions of the system I currently manage, therefore I need to...
asked by 06.07.2017 / 23:12
0
answers

Problem with the Apache Xampp

I have to use PostgreSQL for a job and I enable the pdo and the extension of postgres in the file php.init and the same does not connect me with the tables, I realize that in the console I place the command: php -m The postgres do...
asked by 16.06.2017 / 20:48
0
answers

Syntax error in Postgresql in java

I have two tables to save detail, save file and I want to create a view of some of the columns of save file, the problem is that I am presented with a syntax error that I can not solve String SQL4 = "INSERT INTO DetalleGuardarFactura (Nombr...
asked by 26.03.2017 / 17:34
1
answer

SQL - Group query result in a field

I am programming a script in php and I have created the following query: SELECT t2.id_usuario, t3.nombre, to_char(t1.fichaje_fecha, 'YYYY-MM') AS mes ,SUM(CASE WHEN t1.operacion = '+' THEN t1.tiempo ELSE '00:00:00' END ) AS "positivo" ,SUM(CAS...
asked by 24.03.2017 / 17:43
1
answer

Postgresql consultations with Sequelize stop working suddenly

I am currently in charge of a system developed in NodeJS, which uses PostgreSQL as a database, and we access it using the Sequelize ORM, all this in the Heroku platform. The problem I face is that, at a certain point, I tried to make a new de...
asked by 10.03.2017 / 14:54
2
answers

Given a JSON key show a record - PostgreSQL

I need to obtain the record that is inside a table in which there is a JSON column in which one of its keys matches a given one. SELECT json_object_keys("Localizacion") LIKE 'prop1' FROM ejemplo "EstanciaHospitalaria" Returns if in each...
asked by 28.11.2016 / 13:21