Questions tagged as 'postgresql'

Tagged questions
1
answer

Export dump data from Oracle to MySQL / PostgreSQL

I'm looking for the right way to export a Oracle g10 database from 16 gigas to MySQL and / or PostgreSQL em>. I say export because I want to have the new data dump formatted for MySQL / PostgreSQL and then do the migration. Mai...
asked by 11.03.2017 / 14:18
0
answers

PostgreSQL connection with C #

then I leave the code I am using to connect and insert records in my database NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;Port=5432;Database=demoluis;User Id=Luis;Password=micontraseña;"); conn.Open(); Npgsql...
asked by 13.03.2017 / 08:59
1
answer

After installing PostgreSQL I try to access the localhost and I get a message that the page does not exist

I am starting a web page project which I will do with Django , to make it more complete I will use PostgreSQL to manage the database. I already have installed the python with which I also have a good experience and I also have installed...
asked by 06.03.2017 / 19:00
2
answers

pg_hba.config shows me error on the server

I am connecting to the database through an ip from Linux to Windows but when running the project in Linux it shows me the following error, and I do not know how to solve it: I would appreciate the interest.    SQLSTATE [08006] [7] FATAL: the...
asked by 22.02.2017 / 18:10
1
answer

Connecting PosgreSQL 9.3 with Crystal Report in Visual Studio 2015

I can not count the number of hours I've spent invested to solve this problem but there it goes: I have a report in crystal report and I need to connect it to the bbdd PosgreSQL 9.3 but without ODBC, through a connectionstring or whatever, the c...
asked by 10.03.2017 / 13:09
1
answer

Replace multiple characters within a string in PostgreSQL

I have the following problem. I use PostgreSQL and I have a string with multiple values that are repeated. I need to take that value and replace it with another value from another table. Example    String cadena = "Se actualizarón or...
asked by 15.03.2017 / 00:13
1
answer

Help with sql view

I'm stuck in an exercise for class, the teacher has also tried to help me and has not finished leaving ... the statement is as follows: Create a view, called top_patients, that collects the patient from each city that has spent more on visits...
asked by 02.02.2017 / 17:18
0
answers

Read disk files with Postgresql

Hello, someone knows how to read files stored on the client machine disk from postgresql, also if it is possible to filter the search by the file extension. For example .SQL on sql server used EXECUTE master.dbo.xp_cmdshell 'dir /b "C:\Fol...
asked by 08.02.2017 / 01:37
1
answer

Create Store Procedure in PostgreSQL [duplicate]

I want to create a store procedure in PostgreSQL but I see that it always has a return, what I need is to make a simple LIKE I do not need to return anything, this is my query has syntax errors for example it is missing an AS after the name of...
asked by 11.01.2017 / 21:47
0
answers

How to pass the following pseudocode (Algorithm Top down Time Ratio) to R language (R-Project)

I am using a database in Postgresql of trajectories vehicles and I want to use the following algorithm in R to compress the trajectories. #algoritmo top-down time-ratio procedure TD_TR(s,dist_threshold) if len(s) <= 2 then return s e...
asked by 08.01.2017 / 18:13