Most voted "postgresql" questions
Postgresql is an open-source, object-relational database management system (ORDBMS) available for many platforms, including Linux, UNIX, MS Windows, and macOS. Please mention your version of Postgresql when asking questions.
Learn more…1,437 questions
Sort by count of
-
0
votes1
answer106
viewspg_dump with Plink.exe(Putty)
I need to run some ssh commands on my linux server, from a windows machine via cmd. For this I am using Plink.exe Commando: plink -ssh [email protected] -pw 12345 -m script Script: pg_dump -U master…
-
0
votes0
answers40
viewsError inserting Multiple PHP + PDO + POSTGRESQL Lines
I am using Multiple Insert, but the internal characters of the text have caused Insert to fail. I used the addslaches method in the string but the error remains, some hint of what I can do to…
-
0
votes1
answer39
viewsHow do I enable Rails to support multiple open connections to the data cluster?
I use Postgresql in my API and if my GUI (Navicat) is open accessing the application database and try to run the command db:drop db:create db:migrate db:seed get the error below:…
-
0
votes1
answer188
viewsINSERT command in php is not working
I’m passing a PHP project I did on the local server to a paid server. When I was only using the location of my machine, everything worked. However, when I passed the whole program to the new server,…
-
0
votes1
answer65
viewsUPDATE field BIGINT[] from a SELECT
I have an update to a field permissao_ver Being the same guy bigint[], field response : '{1,2,3,4,5,11,44,56,75,11}' My Query UPDATE callcenter.pausa SET permissao_ver = '{"(SELECT cod_grupo FROM…
-
0
votes0
answers319
viewsLosing database connection. Postgress, Glassfish
After about 15 minutes my system stops communicating with the database. Log Entry Detail Close-up Timestamp 05/09/2016 21:22:30.287 Log Level ERROR Logger…
-
0
votes0
answers422
viewsPgadmin4 - Empty Data Output
I installed Pgadmin 4 on my machine with windows 10 64bits, I configured the server, but when I open some table the query seems to run normally, but the tab "Data Output" shows nothing, neither…
-
0
votes1
answer664
viewsQuery to separate records
Good afternoon guys, I’m having trouble performing a query. Have the following table I would like to make a query that shows which and how many status_telefonia had by phone and date, then create a…
-
0
votes1
answer56
viewsWindows Scheduling System ,SQL
How do I create and run a sql(postgresql) command on the windows scheduling system? My problem. I have a postgresql database where I have two tables. One is client and the other is disk lease. I…
-
0
votes1
answer403
viewsAndroid - Connection to Postgresql
I’m trying to connect the Android directly with PostgreSQL. Include in the project package: postgresql-9.1-903.jdbc4.jar and I’m using PostgreSQL 9.1. But I can’t successfully make the connection. I…
-
0
votes2
answers1769
viewsExecute SQL command in the terminal
I’m wanting to run sql command through the Windows prompt but I don’t know what the initial settings to do this. Can anyone tell me? Detail: It has to be in the windows terminal.
-
0
votes1
answer3263
viewsHow to assign the query cost to a variable in Postgres
To take the cost esteemed of the query use the EXPLAIN SELECT coluna FROM tabela;, to take the cost current of the query use the EXPLAIN ANALYSE SELECT coluna FROM tabela;, my doubt is how to search…
-
0
votes0
answers113
viewsQuery takes time to complete
Good afternoon, you guys, am having a problem executing a query in c# using NPGSQL. try { bdConn.Open(); NpgsqlCommand sql = new NpgsqlCommand(); sql.Connection = bdConn; sql.CommandText = query;…
-
0
votes1
answer577
viewspostgres compare time extracted from a timestamp
I need to extract the hours and minutes of a timestamp in mysql, I tried to use maketime(); CREATE OR REPLACE FUNCTION agendar(dia timestamp) returns bool as $$ declare hora time := extract(hour…
-
0
votes0
answers66
viewsmysql error while trying to insert a timestamp
I’m trying to pass a timestamp per parameter for a Function, but I end up getting an error ERROR: invalid input syntax for type time: "10" the stretch where I pass is: select agendar('2010-01-01…
-
0
votes1
answer88
viewsMongodb integration with ASP.NET MVC 5 and Postgresql
I am building a project in ASP.NET MVC 5 with Postgresql database, in this database there is a history table that will grow in about 500,000 lines per month and we will have reports that will gather…
-
0
votes1
answer294
viewsID sequence advances +1 during error [Postgresql]
I have the following table in the database in postgresql The fact is that the column Description is unique_key so for testing issues I decided to insert some records with the repeated values in the…
-
0
votes1
answer356
viewsMigrate Firebird Delphi 7 Application to Postgresql
I am trying to migrate an application that was developed in Delphi 7 and that uses the database Firebird to save your information, to the database postgresql, from this, I have already been able to…
-
0
votes2
answers413
viewsDisplay 5 latest postgresql results
I need to display the last 5 results of a query, but I do this query twice because I need to change the Where clause, to return the values I need. I thought of something like: SELECT id, project_id,…
postgresqlasked 7 years, 8 months ago Marcos Henzel 797 -
0
votes1
answer426
viewsUpdate with calculation
I have a product table and I want to calculate the profit margin based on the columns preco_venda and preco_custo I did as below: update produto set…
postgresqlasked 7 years, 8 months ago Ronailson Gomes 11 -
0
votes0
answers20
viewsHow can I generate a php report that is not a table?
I need to create a report/form from a query in php. I have a membership database for a leisure activity club. From this query: SELECT DISTINCT utilizador.nome, utilizador.data_nascimento,…
-
0
votes2
answers527
viewsFormat date when performing Update in the registry - Postgresql
I am saving in my database the date that certain record is changed, however the format that it is saved is (YYYY-MM-DD), the SQL command used so far is as follows:: update public.transportadora set…
-
0
votes0
answers177
viewsLiquibase. sql file not found
When I run liquibase it does not find . slq files configured by tag. Sqlfile. how to solve this? Data from the problem: Design use of liquibase 3.4.2. Configured the Maven plugin Execute script in…
-
0
votes2
answers848
viewsSpring-Boot + Thymeleaf, load data into Bootstrap modal window
Good afternoon! I am using spring-boot and Thymeleaf to develop a java application, I would like to know how to load records to the modal window of bootstrap by clicking on the link of the table…
-
0
votes1
answer136
viewsFill null field with first previous null field
Good afternoon, I wanted to fill in the null fields with the first non-null previous field in a whole table. You know if you can do it? Like this the table: How should the table look:…
postgresqlasked 7 years, 7 months ago S. Marco 1 -
0
votes1
answer130
viewsExport DESCRIBE TABLE from Postgres to txt
Is it possible to generate a file . txt with the DESCRIBE TABLE of a table in Postgres by PHP? I need to make a file download available. txt with the description of the fields(name, type, character…
-
0
votes1
answer999
viewsIf exists update Else Insert in table with foreign key postgres
I need to do an Insert in a table with a foreign key, so if this record does not exist in the other table I need to do an Insert, can I do this operation using if exists? Some solution?
-
0
votes1
answer410
viewsDisplaying quarterly data up to the current POSTGRESQL date
According to the SQL Fiddle, I am displaying the quarterly data of a table, however, this query is only displaying when it has value in the quarter (3, 6, 9 or 12), when it has value for example in…
postgresqlasked 7 years, 6 months ago Marcos Henzel 797 -
0
votes0
answers27
viewsRemove Row from table and adjust Ids
Greetings. I’m a beginner in the database and wanted to know the correct way to remove an item from the table and update the identification number of the others. This is the typical novice problem,…
-
0
votes1
answer772
viewsMerge database with java application
Hello, I did a college job using java screens using the ide netbeans, crud the database ,using postgresql as the main database, I was able to finish and everything, however I would like to send only…
-
0
votes1
answer640
viewsHow to select the records of a high box table in postgres?
I need to select all records from a table where the letters of a given column are in the upper case (Uppercase). Is there a function that does the case/minuscule differentiation in POSTGRES? Here is…
-
0
votes1
answer1510
viewsCreate Server in pgAdmin 4 with external IP
I am trying to create a server with external IP in my pgAdmin 4, but the following error occurs when I try to save it: Accessing the file pg_hba.conf I found that the same is so currently: TYPE…
-
0
votes1
answer469
viewsAssign value to a Boolean variable according to selected Radio Button
I’m trying to implement my application, where the table empresa won a new column called status, which would be completed in accordance with Radio Button this would serve so that when generating the…
-
0
votes1
answer221
viewsError passing script from Firebird database to Postgresql
I’m trying to pass a script for creating and inserting data from a Firebird database to Postgresql, but in some tables there is a syntax error, I am using the SQL Manager Interbase & Firebird…
-
0
votes1
answer234
viewsHow to change maximum limit of simultaneous connections to db
When I exceed 100 connections, I get error: "FATAL: remaining connection slots are reserved for non-replication superuser connections" How to change the parameter of postgresql.conf max_connections…
postgresqlasked 7 years, 5 months ago luanfvieira 13 -
0
votes1
answer38
viewsMark lines where balance sum = 0
I have a table like this below, with the date, one, debit amount, credit value, and the balance sheet value (debit value + 0 - credit value) and I need that each time there is a debit and credit…
postgresqlasked 7 years, 11 months ago thiagofred 180 -
0
votes1
answer93
viewsPgbouncer does not connect via service in windows
I installed pgbouncer as a service in windows 10 using: pgbouncer.exe --regservice <pgbouncer.ini> Placing the ini path and from the folder where the pgbouncer exe is. The service is installed…
-
0
votes0
answers419
viewsNodejs with Relational Database
Guys, I came on a two-way road and I don’t know which one to go on. The problem is this: I’m started developing an application that is basically similar to a social network, will have chat,…
-
0
votes1
answer2689
viewsPostgresql: ERROR: Operator does not exist: bigint ~~* Unknown
I’m making a pagination filter in cakephp, but when I type in a phone number to search, it returns the following error: Error: SQLSTATE[42883]: Undefined Function: 7 ERROR: Operator does not exist:…
postgresqlasked 7 years, 11 months ago Marcos Henzel 797 -
0
votes1
answer30
viewsIndexing BD records
I recently circled a EXPLAIN ANALYZE in my database which is fairly large, about 800mil records in some tables, and I noticed that the indexing methods adopted were not the best. I always let the…
-
0
votes1
answer137
viewssubconsulta with 3 different tables using ilike in postgres
I’m having a question. How do I search a given text using ilike to know if this text exists in 3 related tables. ? I tried to exist but it did not give CREATE TABLE metodo ( id SERIAL NOT NULL,…
-
0
votes2
answers78
viewsFailed to make a database change
When I’m gonna make a Update on the table Impressora my program is closing itself, while debugging the program the following error has been accused: My Update is this way: begin if…
-
0
votes0
answers85
viewsJava EE server error on Jboss server
Hello. I did a project in Netbeans on a computer and it works fine, but when I try to run the same project on another computer it returns this error: Implantando…
-
0
votes2
answers179
viewsTool to generate poco
I have a postgre bank with several tables and I need to generate their classes. Is there a free tool that manages the pocos to be used with EF6? I searched but did not find. I am using VS2015 and…
-
0
votes1
answer333
viewsConnect Pgadmin via SSH Google Cloud
Good people, let’s go. I have a server in Google Cloud, and I installed the postgres and everything ok, is working beauty, then on my machine I installed the pgAdmin III and made the configuration…
-
0
votes0
answers1702
viewsError in Backing up Postgresql: Exit code 1
I’m trying to back up a bd in postgresql - First when I open it always makes an automatic Restoring that never ends Trying to back up Give me that answer, and don’t back up the bank…
postgresqlasked 7 years, 9 months ago Rodrigo Jacinto 355 -
0
votes0
answers1172
viewsError postgre trying to access externally
I am using NO-IP to connect to an internal server in my office. I’ve already released port 5432 on the machine’s firewall and I’ve also set up the pg_hba.conf and postgresql.conf files (I’ll leave…
-
0
votes3
answers290
viewsDoubt with Insert in Postgres Bank
I have an error message, tried several options of not getting a solution. Is there any configuration that is missing?…
-
0
votes1
answer1610
viewsRecord app data developed with React-Native in a remote Postgresql database
Good I’m developing an application in React-Activate. In this application will basically have some forms to register information, but this information must be saved in a Postgresql bd which is…
-
0
votes1
answer562
viewsError conversion type Object to int
I am making a select in the database, using Execscalar returning an Object but I cannot cast this value returned to integer. public static int ConsultaPDVsAtivos() { NpgsqlCommand sql = new…