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
------------------- ------------...
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...
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...
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...
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...
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 (...
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...
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...
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...
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...