Talk to people,
I need to create a structure template in which all my tables have a primary key consisting of id and version, so I can have multiple versions for each id.
Problem:
CREATE TABLE table1 {
id BIGSERIAL,...
I have the following scheme:
JdbcRowSet myrs = new JdbcRowSetImpl();
myrs.setUrl("jdbc:postgresql://localhost:9999/teste");
myrs.setUsername("postgres");
myrs.setPassword("");
myrs.setCommand("select count (*) from pessoas where cpf = '12345'...
Personal I have the following problem:
I have a file in txt format with the following information:
1;Helder;Masculino;GO
2;João;Masculino;RJ
3;Maria;Feminino;PR
4;Pedro;Masculino;MA
I used this example to test the import to postgres 9.6, bu...
I need to return the name of the month with the command select , I know that with the command
Select extract('Month',data)
It returns me the number of the month in question, there is a way to bring in that month.
In case: 0...
I have the following select
SELECT u
FROM User u
WHERE lower(u.fullname)
|| lower(u.username)
|| lower(u.email)) LIKE %:pesquisa%
It turns out that I want to do the search by any of the 3 existing fields, but the email is no...
We are updating a system developed in Delphi that stored the data in access tables for PostgreSQL. So far so good, however, I came across the following situation:
In the old bank we had the following tables to store the movements:
notafis...
I have a field in a table in a PostgreSQL 8 database whose values are strings and have hyphens in some irregular positions.
I would like to replace the first occurrence of the hyphen in the string with a space, but I could not find anything a...