Questions tagged as 'postgresql'

2
answers

Refresh and insert data into a table with information from another in another database

I have the following situation: Bank and the B bank both with the Customers table with the following data: A.clientes B.clientes id | nome id | nome ------------------- ------------...
asked by 12.01.2017 / 15:45
0
answers

What Types of PostGis data are these

In the Postgis 2.3 documentation in part 4.2 PostGIS Geography Type, it is mentioned that the following types are supported. POINT LINESTRING POLYGON MULTIPOINT MULTILINESTRING MULTI...
asked by 31.01.2017 / 18:12
1
answer

Algorithm for popular tables in PostgresSQL

I'm writing an algorithm to populate all tables in a database in Postgres. I already get popular all tables that do not have a relationship , as follows: I get all the tables with the following query: SELECT table_name FROM information_s...
asked by 26.12.2016 / 16:33
0
answers

View + PostgreSQL problem

I have a problem with a SQL query. Here is the query example: SELECT col.ad_client_id, adu.ad_user_id, col.ad_org_id, col.c_order_id, col.created, col.createdby, col.updated, adc.updatedby, col.isactive, cb.c_bpar...
asked by 13.12.2016 / 17:49
0
answers

Problem with PDO extension Postgres

I use apache + php7 + postgres on Ubuntu and it works fine. But now I wanted to do the installation by hand in Windows 8.1 and found a problem: I installed Apache 2.4, PHP 7.1, and Postgres. Apache worked fine, but when I test my projec...
asked by 25.01.2017 / 02:57
0
answers

Comparison of geographic points in postgres

I have a structure something like this: A veiculo table where I store the id and the placa of the vehicle. A estacionamento table where I store nome do estacionamento , id , and area of it (...
asked by 09.12.2016 / 15:07
1
answer

SQL: Record counter with data grouping of different fields

I'm having a hard time building a SQL. I have a address table with the street and crossover fields. I need to count the numbers of records that have the same crossover and group them together Example: id | rua | Cruzamento 1 | Rua Brasi...
asked by 12.12.2016 / 03:21
1
answer

Python / Postgres

Hi, Is it possible to install a localhost server with Python / PostgreSQL? I know it's possible with PHP / MySQL, like XAMPP, WAMPP, etc. I need to run a system that uses Python / PostgreSQL and my server is a shared Hostgator and does not...
asked by 15.02.2017 / 23:26
0
answers

How to use PostgreSQL with Entity Framework? [closed]

I have a system that I'm developing in C # WPF using PostgreSQL as DBMS and wanted to use this same database for my ASP.NET MVC application. Is it possible to have the Entity Framework have access to the data that is in the PostgreSQL DBMS to...
asked by 17.02.2017 / 00:24
0
answers

SQL query time optimization [closed]

I have a database that stores precipitations marked by multiple sensors at certain dates and times over a year. I am making a query, to fetch all records marked by a single sensor, with the following SELECT p.latitude, p.longitude, h.precipitaca...
asked by 22.11.2016 / 13:57