Good morning.
I have two tables in the same database, with the same name, but in different schemas. I want to compare the records you have in them, to see if there are identical data. Are there any software that does this?
I have a select that displays the names, date and values paid by clients.
I have to display a list without repeating the names.
SELECT
c.name,
p.created_at,
p.amount_paid
FROM
payments as p,
clients as c
WHERE
p.crea...
Good morning,
Every time my machine connects to the internet, its IP changes.
My question is ... How do I always get access to PostGreSQL even though the IP of my machine changes?
public class ConectarDB {
private static Connection con = n...
I need to update a column according to the contents of two other columns, for example, I have two tables, the suprimentos table and the estoque table,
Supplies table codigoSuprimento capacidadeSuprimento
I...
One of our systems is displaying the error below:
Connection is not associated with a managed connection.org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6@437f90c8
This error has happened a lot, but we can not figure out why.
Search...
Good afternoon! Firstly, this is the first post I post in the forum and I am a beginner in PostgreSQL / PostGIS. I'm working on a project that involves spatialized database in which I need to find the best way to display in PostgreSQL the metada...
Hello, I have all the base scripts in postgreSQL and I wanted to transform into Liquibase xml to use on my server. Is it possible or do I have to manually convert scripts?
I have the following query:
SELECT SUM(ValorBruto)
FROM faturas
WHERE DataCaptura between'2018-10-01' and '2018-10-30'
The result is displayed to 4 decimal places. I would spend only viewing 2. How do I?
I need to show the departments that had stock movements in Feb / 2018 and those that had in March / 2018. I need to use a joining operator to show the results of the two queries each returning the departments for a month. In every query I should...