Questions tagged as 'postgresql'

Tagged questions
2
answers

Django, Do not send data to the bd with ajax

By pressing the submit button of the form. go to the error function of the script.js file, when looking at console " POST / HTTP / 1.1" 200 28518 , the database is postgres. is not saving the data, I have reviewed several pages online bu...
asked by 06.11.2018 / 14:51
1
answer

Execute GRANT statements to a remote database in Postgres

I would like to automate the grant action for a given user (myuser) to all databases within a Postgres instance (from the base / Postgres user) . My first attempt was to make the following script: select dblink_exec('dbname=mibase host=IP u...
asked by 07.11.2018 / 17:17
1
answer

Is there a log of the querys executed in Postgresql?

I have been using postgresql 9.3, I would like to know if there is any log of the querys executed, and if there is a way to activate it so that one is generated     
asked by 07.10.2018 / 01:35
1
answer

Error 500 when sending POST with GPRS module SIM7100A, the data arrive null

and I tried to make a publication on the Thingspeak platform but the operation returns an incorrect request of 400, and I tried a publication with another test platform and got 200ok, but thingspeak did not work for me, the commands I use are as...
asked by 02.11.2018 / 11:50
2
answers

How to recover the id inserted with callablestatement from a storeProcedure in java

good day, I hope and you can help me, what happens is that I want to recover the id inserted when I execute a function in postgresql, but the problem is that it brings a 0 since the sp runs and adds it to the view of the datatable but then I rel...
asked by 01.11.2018 / 19:43
1
answer

Consultation in field of the same Laravel table 5.5

I'm working the Laravel 5.5. I have a table called servers, in this table I insert both physical and virtual servers, and identify them through the following field. {!! Form::mySelect('id_uso', 'Uso', [0 => 'Escoge una opción'] + App\Uso...
asked by 16.08.2018 / 16:51
1
answer

Data type to store Postgresql coordinates

Good evening I have a database in Postgresql and I want to add two fields to store latitude and longitude, I read in several blogs that the field should be floating (float), and my question in particular is whether this statement is correct and...
asked by 06.08.2018 / 00:51
1
answer

See if two dates overlap

I have to make a query that consists of checking if the start date that they insert me and the end date that they insert me is not included in another existing article, that is: Artículo { Id:1 Nombre:'mesa' F_ini: 1/7/2018 F_fin : 31/7/2018 }...
asked by 23.07.2018 / 09:47
1
answer

Relationships in BD

Hi, I have a question about a relationship and I would like to know if this is a wrong way or is there a better way? These are sample tables, suppose that a post is created and this post can have many comments and can also have many responses, b...
asked by 11.07.2018 / 17:07
1
answer

How to make Google Chart work with SQL (Postgres)

Currently I want to make a query with a standing graph but I can not get it to show me the results, I'm not very versed in php so I guess it must be a beginner's mistake. This is my code: <?php //Invoco el archivo de conexion: in...
asked by 26.04.2018 / 16:39