Most voted "postgresql-10" questions
None
Learn more…14 questions
Sort by count of
-
3
votes1
answer1932
viewsHow to access the postgres of a Docker image?
Greeting, I just created a Docker image of the Postgresql database with some additional settings as shown in the command below: docker run -p 15432:15432 --name kwandb -e POSTGRES_USER=postgres -e…
-
2
votes0
answers81
viewsCalculation of Due Dates Based on Number of Plots Chosen
In a function I want to put the parameters that would: Number of Plots and Total Value My problem would be how to generate maturity dates of installments in Postgresql how to work with the dates to…
-
1
votes1
answer98
viewsPostgresql 10 - Parallel Settings
There are 4 settings to enable the parallel and make the optimizations, but the documentation Postgresql does not say anything about values or calculations. My questions are: 1- How to calculate the…
-
1
votes1
answer65
viewsWhat SQL Script in Postgres to return the Functions of a Schema?
What SQL Script in Postgres to return the Functions of a Schema with its input parameters ?
-
1
votes0
answers89
viewsrake:db setup error (failed to connect to postgresql) in the Ubuntu subsystem for Windows
Hello! I am using the Ubuntu subsystem (18.04) in windows com ruby on Rails (ruby version 2.5.1 and Rails 5.2.2) and with Postgresql in version 10. I surrounded a rake db:setup at the root of my…
-
1
votes1
answer31
viewsPsql -c is lowering my table name
Hello, I am executing the following command: psql -d copia-local -U postgres -c "COPY "Questions" FROM '/home/pedro/Documents/PostGre/data/cooked/Questions_cooked.txt' WITH DELIMITER '|' NULL AS ''"…
-
1
votes1
answer139
viewsError starting Postgresql - [FAILED]
I’m trying to upload the database, but when I give the command service postgresql-9.1 start appears the following message: Starting postgresql-9.1 service : [FAILED]. I went to the log file with…
-
0
votes1
answer150
viewsWhich Postgres SCRIPT to list all Schemas?
Do I need to know which script I use to list all the Schemas of a Database ? 1 Condition is to list all Schemas I created and do not need Postgres Schemas I need this information to be able to…
-
0
votes0
answers83
viewsPostgresql, csv file import
I am having a lot of difficulty trying to import the CSV file using PostgreSQL, apparently the program is not able to read the file, but granted permission in all users and folders of the operating…
postgresql postgresql-administration postgresql-10 postgresql-11asked 4 years, 5 months ago Lucaa 5 -
0
votes0
answers28
viewsHow to get a word from a certain letter inside a String in Postgres
I’m trying to get a word from a certain letter inside a String in Postgres. I’ve tried several ways, but I haven’t succeeded using substring, strpos… In the select below, I need to pick up the words…
-
0
votes0
answers9
viewsPOSTGIS ST_DWITHIN. Distance from radius
good night If anyone can help me... I need to know if a B point is within 100 metres of point A. both point A and point B are of the Geometry type. I’m using the function ST_DWITHIN. This function…
-
0
votes0
answers66
viewsProblems performing Postgresql Store
I’m having trouble performing the Store from a dump. The scenario is as follows: I am migrating from a GCP environment to AWS, and at this time I am working on the bank migration. A partner dumped…
-
-1
votes1
answer77
viewsWhich SQL Script in Postgres to return the fields belonging to PK?
Which SQL Script in Postgres to return the fields belonging to the primary key of a specific database table ?
-
-2
votes1
answer186
viewsCheck Array(STRING) in Postgres column
Good afternoon, everyone, I need to UPDATE a table, but for this I need to compare if the values of an ARRAY(STRING) are inside a column of this table, example: UPDATE tabelaTeste SET versao = '2'…