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
-
1
votes2
answers1565
viewsLogin to Postgresql and PHP
Good people, I’m a beginner in programming and I’m learning in PostgreSQL since I know how to work in mysql and a little in PHP. I am creating the login form with PostgreSQL and PHP And I’ve been a…
-
1
votes2
answers389
viewsMD5 is good enough?
I’m working on a legacy system, which has a database with about five years of accumulated records with no normalization. Among other things, its purpose is to allow users to write and post posts in…
-
1
votes0
answers36
viewsMysql doubt in fk null (Blank candidate election)
I’m doing a voting system and I need you to take blank votes what is the best option to do this? agree to pass a null value in the cd_candidate column? I can’t create a blank candidate in the…
-
1
votes1
answer49
viewsPostgresql problem
After a power outage we restart the server in which the database is located and although we try to lift the bank manually the bank does not raise. The message that occurs is this below: FATAL: The…
-
1
votes1
answer132
viewsRestore container base with Postgres
I am using a container with postgres on an EC2 server and want to restore a base in this container via linux command. Any tips? I was trying this way: sudo docker exec -t postgres_94 pg_restore -c…
-
1
votes2
answers164
viewsPostgresql pg_hba.conf
I have a server with a Servlet + a postgresql database. I would like only Servlet to connect to the database. When I set up pg_hba.conf with local all md5 Servlet cannot connect to the database.…
postgresqlasked 8 years ago Edson Santos 416 -
1
votes0
answers203
viewsNpgsql failed to call plpgsql function
I’m running some tests on the Npgsql. One of the tests tests the return of a plpgsql function. But the test is failing saying that the function does not exist. In the error description the name in…
-
1
votes3
answers333
viewsProblem saving accent with Entity Framework and Postgresql
I need to migrate a system with SQLSERVER database to a Postgresql 9.3. I’ve never worked with Postgre before so I’m using Entity Framework 6 with model-first to make the process easier. The…
-
1
votes2
answers362
viewsIs it possible to store user inputs by the Scanner Class in a database?
I have an application made in Java, and I need to store the user’s registration information in the database: Cpf, password, name, address, telephone System.out.println("Digite seu CPF"); cpf =…
-
1
votes1
answer263
viewsBD modeling for "multi-level marketing"
Personal talk, I’m working on an app that consists of people referral, same as so-called multi-level marketing. The general idea consists of: Person A indicates person B (LEVEL 1) if person B…
-
1
votes1
answer34
viewsError trying to access certain bank information
I am trying to access certain information from my database, but the following error is occurring: Chunk where when debugging error occurs: IdHTTP := TIdHTTP.Create(nil); IdHTTP.Port := 80;…
-
1
votes1
answer284
viewsComparison with recorded data such as JSON
I have a date field that is saved to the field in JSON format, along with other values {"data_limite":"14\/07\/2016","data_programada":null,"admin_agendamento":"4813"} This field "deadline", I need,…
postgresqlasked 8 years, 4 months ago William Aparecido Brandino 848 -
1
votes0
answers78
viewsOptimization of SQL query time
I have a database that stores precipitation marked by various sensors on certain dates and times over the course of a year. I am making a query, to search all records marked by a single sensor, with…
-
1
votes0
answers566
viewsHow to install Npgsql as a data provider for ADO.NET Entity Framework?
I’ve read everything you can imagine, but I’m out of luck. In Visual Studio 2015 Enterprise update 1, I followed exactly the steps as you describe the tutorial on the page…
-
1
votes2
answers720
viewsUpdate date at each update in a table
I have a table pessoa. In it I have a field called pe_modified which aims to have the date of the last modification in the table. Instead of me having to update on the query, is it possible to be…
-
1
votes2
answers81
viewsIs it possible to make Postgresql database data visible or not, without erasing it?
I have an application where in addition to registering and consulting clients, it allows to issue reports with customer information, the problem is that many of these customers already registered do…
-
1
votes0
answers354
viewsError connection with Postgresql
I’m having trouble connecting an Asp.Net MVC application with Postgresql (Ocaweb). error: 28000: no pg_hba.conf entry for host "187.52.54.50", user "dadosportal", database "template1", SSL off…
-
1
votes1
answer190
viewsSQL: Record counter with grouping of data from different fields
I’m having a hard time building an SQL. have a table addressee with the strings fields street and crossing. I need to count the numbers of records that have the same crossing and group them Example:…
-
1
votes1
answer588
viewsIs it possible to leave connectionString dynamically?
I’ve read something and I know it’s possible to leave one connectionString dynamically in an ASP.NET MVC application. However, it is possible to create n connections where each authenticated user in…
-
1
votes1
answer145
viewsSuggestions apache tools to develop in php with Postgresql
Good people, I’m wanting to develop in php, and for that you need to install a tool that makes my pc become half server, as everyone knows there are several tools to download, as: XAMP, WAMP,…
-
1
votes2
answers4035
viewsGenerate Postgresql Server backup with password via command line
I need to perform an automatic Backup of a Postgresql server, I have a command that makes this backup but it always asks me the password and I could not find a command where I can already determine…
-
1
votes1
answer997
viewsAccentuation problem in postgresql with npgsql
I have a database postgresql raised with encoding SQL_ASCII and template0. When I try to select lines with accents like NAY gives error, but if the records have no accent works normally. Mistakes:…
-
1
votes1
answer374
viewsImprove search performance when there is no record
I have a database with 9551011 lines. It contains addresses from all over the country. When I make an appointment for a certain place, and that address exists in the bank, I can get a return within…
-
1
votes1
answer158
viewsRemoving "BC" from Timestamp dates in Postgresql
Hello, I’m trying to remove "BC" from sql dates but I’m not getting. I’ll tell you what: SELECT CAST("regiaulaavul_dataInicio" AS date) FROM "RegistroAulaAvulsa" And eventually return me the date…
-
1
votes2
answers259
viewsPython/Postgres
Hi, Is it possible to install a localhost server with Python/Postgresql? I know it is possible with PHP/Mysql, like XAMPP, WAMPP, etc.. I need to run a system that uses Python/Postgresql and my…
-
1
votes1
answer211
viewsSelect with cast(Numeric as decimal) works, but view creation does not
Good morning to all! I currently work with postgresql and am doing a database migration, and need to create a view of my old database tables. Well, I need the numerical columns to be rounded 15.3…
-
1
votes1
answer117
viewsTransaction in Postgress on Nodejs
I’m looking to encapsulate my SQL execution in the Postgress database. My initial wish is to call a method to execute a specific query and another method to execute a transaction of various queries.…
-
1
votes2
answers950
viewsHow to ignore accentuation in a database search?
I need to conduct a city search. 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 by typing Sao Paulo…
-
1
votes0
answers256
viewsHow to use Postgresql with Entity Framework?
I have a system that I am developing in C# WPF using Postgresql as DBMS and wanted to use this same database for my application in ASP.NET MVC. You can make the Entity Framework have access to the…
-
1
votes2
answers970
viewsHow to connect Virtual Android with Postgresql on Local Machine?
Good morning, I’m trying to make a connection to Android Virtual servant in the Eclipse ADT with JDBC do PostGreSQL 9.1. To my knowledge in Android it’s little I spent a lot of time trying to…
-
1
votes1
answer118
viewsProblems with creating not null fields with Fluentnhibernate
I have a problem creating the fields using Fluentnhibernate and Postgres. User class: public class Usuario { public virtual int idUsuario { get; set; } public virtual string nome { get; set; }…
-
1
votes1
answer244
viewsInsertion of dates in Postgresql
I would like to know how to configure the Postgre to accept date entries as follows: "12122016". I know that with the same "spelling" is possible with YMD more I would like to know how to set up to…
-
1
votes0
answers83
viewsSave IP server data
Good morning people when trying to connect to a server I set up my firewall and configured the files pg.conf and pg_hb.conf to allow remote connections but presents this error could help me ? it…
-
1
votes1
answer148
viewsDelete duplicate lines with postgresql conditionals
My code takes information from the internet and inserts it into the database, however, it inserts the same information more than once a day. I need to leave only 1 record information per day, IE,…
-
1
votes1
answer6599
viewsError connecting to Postgresql by pgAdmin 4
I installed the pgAdmin 4 in my note with Windows 10 and I’m unable to access the database. Host name/address = /198.22.33.44 Gate 5432 Maintenance Database = xxxxxx Username = cesar_r Password =…
-
1
votes1
answer59
viewsError trying to access Database information
I’m migrating an application that was developed in Delphi 7, which used to use the Firebird database, so now I’m making the application communicate with the Postgresql database. I managed, after…
-
1
votes1
answer88
viewsSend text file to Pgadmin
I need a little help, I’m a beginner.I have to send a txt file that I open in netbeans to a Pgadmin table. If you see the code you will understand me. I tried to put my method that shows the txt…
-
1
votes1
answer795
viewsSelect to check where a primary key is referenced
I have the following tables: _________PERSON_________ serial id PK name varchar(50) NOT NULL email varchar(100) NOT NULL tel varchar(14) NOT NULL _________CLIENT__________ integer person FK/PK --(FK…
postgresqlasked 8 years ago Matheus Saraiva 2,157 -
1
votes2
answers113
viewsHow to limit the amount of addresses a user may have in the database
I have a database, and I have the user table and the address table. I need to validate somehow so that a user can have at most 5 addresses in the registry. I use the Postgresql database and it is an…
-
1
votes2
answers152
viewsAdd column in a table already used by a program, could it harm the functioning of it?
I have a Postgresql database that is used for an application developed in Delphi, but now I will have to use this same bank for a new application that will be developed in Java, need some columns…
-
1
votes2
answers630
viewsRemove double quotes in codeigniter query Builder
I am using the Codeigniter framework and every time I create a select with their Builder query, it puts double quotes on all columns and tables. Ex: SELECT "ID", "NAME" FROM "STUDENT" This ends up…
-
1
votes2
answers508
viewsHow do I do INNER JOIN in this case?
I’m a beginner in Postgresql and I need to make a INNER JOIN to relate data from two tables. It took me a long time to understand this FOREIGN KEY, but I made the right reference in the database.…
-
1
votes0
answers137
viewsComparison of geographical points in postgres
I have a structure like this: A table veiculo where I store the id and the placa of the vehicle. A table estacionamento where I store the nome do estacionamento, the id and the area of him (a…
-
1
votes1
answer328
viewsTransfer JSON table columns in Postgres Trigger
I am creating a Trigger in Postgres and would like to turn all columns into JSON to insert in a single column of table 'LOG', I would like to turn for example 'OLD.*' into JSON and add it in column…
-
1
votes2
answers6147
viewsConcatenate columns into a single Postgresql row
I have a situation that would make it much easier. if I could return the data from a specific column in a single row: For example: Table A: Codigo | Descricao ------------------- 1 | Descricao 1 2 |…
-
1
votes2
answers1297
viewsFind the name and number of doctors who have appointments with all patients
No postgres, as Fetch the name and CPF of doctors who have appointments with all patients? Keys: Patient: id_patient Medico: id_medico consultation: id_patient, id_doctor
postgresqlasked 7 years, 4 months ago aquele help maroto 11 -
1
votes0
answers60
viewsProblem with View + Postgresql
I have a problem with an SQL query. Follow the example of the query: SELECT col.ad_client_id, adu.ad_user_id, col.ad_org_id, col.c_order_id, col.created, col.createdby, col.updated, adc.updatedby,…
-
1
votes0
answers528
viewsHow to export a postgres table with column names to csv format with jdbc?
This is my code, which unfortunately does not export column names: package net.viralpatel.java; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import…
-
1
votes1
answer1339
viewsPostgresql - Inserting data into linked tables by Foreign Key
Hello! I’m having a problem inserting data into tables linked by a foreign key. I read in some places that there is a command "with" that helps in these situations, but I didn’t understand how to…
-
1
votes1
answer111
viewsError saving data from a Radiogroup
I’m having a problem saving the information I select in one RadioGroup in the database, after making the change that was suggested in this question the error of trying to add something in the column…