Questions tagged as 'postgresql-9.3'

Tagged questions
1
answer

Switch from PostgreSQL to SQL Server

What happens is that I have a PostgreSQL script and I need to pass it to SQL Server. Does anyone know a tool that is effective?     
asked by 16.10.2016 / 13:19
1
answer

Import data from csv file

I have a csv file which has this data that takes them out of a single field. As you will see, it is not only data from a single field. In the table where I want to insert this data has the following structure. The information I...
asked by 15.10.2018 / 14:56
1
answer

Use of MAX and MIN functions in postgresql

I have a table like the one shown below (simplified example): Customer_ID Orders    1 10    2 15    3 5    4 8 Now I would like to generate an extra column that is the maximum value of the Orders column, that is, in the four rows a 15...
asked by 28.09.2018 / 09:00
1
answer

Know if a table exists or not in postgres

What happens is that I am trying to see if a table exists in postgres or not, I managed to make the query, the problem is that it is consulting if it exists in the whole postgres scheme and not in the base on which I am executing the query and...
asked by 30.07.2018 / 16:27
0
answers

Save GIF in PostgreSQL database

Good afternoon I need some help, what I need is to save a GIF in a postgreSQL database. I have a table called words which counts of 4 fields ...    word of type text description of type text GIF of type text   Bytea type resource In th...
asked by 01.08.2018 / 20:25
2
answers

Help creating a Dynamic Insert in PostgreSQL

I have a table Juego which has 4 columns nombre, tipo, autor, proveedor , the function that I create allows me to enter data filtering according to characters correctly, but I would like to write the columns and the value of the arr...
asked by 13.07.2018 / 00:55
2
answers

postgres primary key change change

Hello having a created table I would like to know if I can change the primary key for example for my table where I want anho to be the new primary key instead of id id | anho | modelo ------------------ 1 | 2010 | new 2 | 201...
asked by 05.07.2018 / 14:09
2
answers

how can I declare a variable in postgresql?

I need to declare a variable timestamp in postgresql but when I try it it gives me syntax error, if someone could give me the code of how to declare and assign value to a variable it would be very helpful, thanks     
asked by 17.05.2018 / 16:05
0
answers

update and concatenate columns POSTGRESSQL

I would like you to help me with this doubt. I want to make an update in a new attribute that I add to my table, the situation is the following when doing that update I want to concatenate three columns. when I execute this code: update saber2...
asked by 01.04.2018 / 05:58
0
answers

Function in Postgresql - Problem with refcursor

Hello everyone I want to know if my code is well raised, it is for me to report but it returns me alone and I tried with the fetch all in ""; commit; but it still does not give me anything back. .... CODE ..... { CREATE OR REPLACE FUNCTION...
asked by 27.03.2018 / 21:45