I am doing a search in the database where I want to return the records of the last seven days. I made a SQL script that returns me the records of the last 7 days but it does not count the current day as being the first day of the 7. For example...
I have a variable of type character varying (17) and need to separate one of the characters, for example the third letter, and use it to filter.
SELECT *
FROM fnord
WHERE terceira(illuminati) = "a"
I created my Spring Boot project, I did not create any Java class and it is already giving error, my problem is to connect the project with the PostgreSQL database.
see my pom.xml file
<?xml version="1.0" encoding="UTF-8"?>
<projec...
Good morning,
I'm trying to create a connection of Android Virtual created
in% with% with% with%. As my knowledge
in Eclipse ADT I spent very little time trying to connect and did not have
success.
public String conectarDB() t...
I am creating .bat files to perform the backup and restore of a database in PostgreSQL I use windows 10 and pg 9.4
I execute the following command to perform the backup
set PGUSER=postgres
set PGPASSWORD=postgres123
"C:/Program Files/Postg...
I have a webservice consuming postgreesql data and when I try to connect to the base after posting.
The host I'm trying to use: "serveripanema.no-ip.info"
Npgsql.NpgsqlException: Failed to establish a connection
to '177.195.4...
Good evening,
How Query can take the following action in PostgreSQL:
List the dates that fell on the Sunday of the last 6 months based on the current date, regardless of the data in the database.
NOTE: The records that are in the data...
I need to search for cities.
In the database is registered for example, São Paulo , Viamão , Curitiba , but if the user tries to search the city of São Paulo for example, typing Sao Paulo (without accent), nothing...
I'm a beginner in Laravel and I'm trying to get data from a DB with multiple Postgresql schemas with Laravel 5.1 and it's bringing me an error
What configuration should I make for the model to correctly access the table of that schema?
Dir...
I'm starting a Windows Form C # project, a business application that the user downloads, installs, and uses without any complications.
Is it possible to configure Visual Studio Installer Projects to install with PostgreSQL without the user reali...