Questions tagged as 'postgresql'

Tagged questions
2
answers

json vs jsonb postgresql

What is the difference between json and jsonb ? The @EmilioPlatzer user gave me an answer to another question where he uses these 2, but I do not see the difference. In fact, the user comments on the following:    json...
asked by 30.04.2017 / 18:13
2
answers

How can I make a sql that contains an array of objects and that those objects contain 2 column data?

I have this sql The result of the 2 columns modelos_id and modelos_nombre I would like to join within objects, I try to do as it says the documentation . Here's what I'm trying to do , the query is as follows: SE...
asked by 30.04.2017 / 03:55
1
answer

How can I enter a data in a table in pgAdmin 4?

I downloaded version 4 of pgAdmin, but when trying to enter a data, I can not find a way to do it graphically.     
asked by 24.08.2017 / 00:52
1
answer

Problems with postgresql prepared queries?

I'm doing a query prepare to avoid the sql injection, but I did not run the page that should show the result, it gives error and I think it's because the functions I'm using are from mysqli, and I'm working with postgresql, I'm not sure if these...
asked by 05.08.2017 / 00:51
1
answer

how to set up a public server with free postgres?

I have to work from two different places with the same database, being in the development stage I need something free (free). Where you can mount a potgresql database and access it from anywhere.     
asked by 05.07.2017 / 23:49
1
answer

PL / PGSQL - How to make the SP "comite" the data

Good afternoon, I have an SP (SP1) that invokes two other SP (SP2 and SP3). SP2 is invoked first from SP1, and updates a record in a table. SP3 is then invoked from SP1, and queries that same record, but returns the previous state as a result, t...
asked by 17.05.2017 / 18:33
1
answer

Tsvector of postgres in Laravel 5.3

I need to create a tsvector field ( link ) of postgres in my table > Documents I already searched in several places how to do it but I can not find it. Schema::create('documentos', function (Blueprint $table) { $table->increments(...
asked by 23.07.2017 / 04:13
1
answer

Switch from milliseconds to a time in hours, minutes and seconds in Java

I have a variable in String and it is the milliseconds that it takes to get from one point to another. I need to put that value in Hours: Minutes: Seconds format I am using Java 6 and objects Date , but when I send this value to...
asked by 10.11.2016 / 15:14
1
answer

"Exception in thread" error "java.lang.NoClassDefFoundError:" exporting sqlserver data to postgresql

using the postgresql importer 9.4.6 the Migartion Toolkit v49.0.4-2 this command was used runMTK.bat -sourcedbtype sqlserver -targetdbtype postgres -allTables -targetSchema public dbo and for lack of several files .jar gives error of:   ...
asked by 29.09.2016 / 17:50
1
answer

From 2 tables insert the information of certain fields in another new table

my new table where I want to insert the data has these columns: gid,cvegeo,nom_ent,nom_mun,nom_loc,longitud,latitud,altitud,geom the other 2 tables have 200 columns, between the columns of these are called the same as the new table the name...
asked by 26.11.2016 / 20:49