Most voted "pgadmin" questions
23 questions
Sort by count of
-
5
votes1
answer58
viewsWhat is the $$ function in posntegresql functions?
Hello, I’m a beginner in postegrsql and I have the following question: When we create functions in postgresql the following logic is usually used CREATE FUNCTION func() RETURNS ret AS $$ BEGIN ...…
-
2
votes1
answer523
viewsError creating a NOT NULL field in PGADMIN " contains null values "
I have a database already created, within it I have a table already created. In it I need to create a field that is NOT NULL. I do everything by the graphical interface that is faster, I click on…
-
2
votes2
answers1472
viewsTrigger that updates record in a table
I need to update an X table whenever there is a change in table Y. I have found numerous examples of how to save the changed records in table Y, both when deleting a record from table X and when it…
-
1
votes1
answer326
viewsHelp with Inner Join: "No space left on device"
I don’t have much knowledge in programming and experience in SQL, however, I need to do a search in a Postrgeesql database (I’m using pgAdminIIII) where I need to join two tables. create table…
-
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
answer1564
viewsUpdate Postgresql by Pgadmin without SQL command, but by Interface
I need to change certain data from my database PostgreSQL for PgAdmin but I’d like it to be straight through the PgAdmin and not through SQL commands, this is possible. For example when I want to…
-
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
answer2563
viewsImport XLS to Pgadmin
I am trying to import a spreadsheet with information from a database table, however, when I try to import, give the following message: field 'md5' must have a value However, there are values in this…
-
1
votes0
answers44
viewsProblem with Login page, redirect
It works well, does not let pass the credentials that are not configured. But when redirecting it to the other, does not work. session_start(); if (!empty($_POST)) { $isim = $_POST['login']; $sifre…
-
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
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
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
votes1
answer1204
viewsPosgresql has no role with superuser how to create a
When I went to check in postgresql has no superuser as I do to change or create a superuser
-
0
votes1
answer69
viewsPurpose of a foreign key name
I am creating tables for a system I am developing and when entering the part of adding foreign key through the interface of PostgreSQL 9.3.17 I noticed you have the field nome to identify this key,…
-
0
votes1
answer60
viewsSwap UTF8 enconding to SQL_ASCII Pgadmin
Good afternoon! I need to know if it is possible to change the enconding of my utf8 bank to SQL_ASCII, without deleting and re-creating the bank! The problem that is happening is that my bank is set…
-
0
votes1
answer20
viewsEdit the Return of a function using postgresql
Hello! I have the following function (using pgadmin and postgresql), and I would like to edit the Return so that in "data output" instead of just "The sum of the numbers is: 10", the " would be…
-
0
votes1
answer29
viewsCounting supervisors in pgAdmin
How can I list the name of each supervisor with the amount of supervised. select f.NomeFunc, s.ID_Superv from Funcionario f inner join Funcionario s on s.ID_Superv = f.ID_Func having…
-
0
votes0
answers186
viewsHow to install postgresql and pdAdmin4 in Pop! _OS (Linux)?
I’m trying to install postgresql and pgAdmin4 in Pop! _OS (based on Ubuntu) For this, I followed more or less the steps of this link: https://wiki.postgresql.org/wiki/Apt sudo apt-get install curl…
-
-1
votes1
answer380
viewsHow do I enable Postgresql in Cpanel?
Good afternoon. I would like to know how to activate Postgres in the Cpanel menu of the database part, I need to create a database in Pg. I have already done the installation in WHM and enabled the…
-
-1
votes1
answer2496
viewsChange Pgadmin4 default browser
Today when opening the PgAdmin4, it opens by default on Edge of my machine. It is possible to change this to the chrome? When just trying to copy the link and paste, it doesn’t work. Unauthorized…
-
-1
votes1
answer207
viewspgAdmin - How to install "system Tray plugin"?
I use pgAdmin 4 in Linux Mint 19.3. Whenever I open the program, in addition to the browser, a pop-up appears saying: Note: Installing a system Tray plugin will Prevent this window being Shown. I…
-
-2
votes3
answers793
viewsHow to delete only records from a field of my table in SQL
Good morning, I would need to delete only those registered from a field of my table. In the case I have the product table and in it has the field dtsanitation and in this field had records. I would…
-
-2
votes0
answers15
viewsQuestion about Postgresql 9.5.25 with pgAdmin 3 that comes installed along with it: how to use command line instead of graphical interface?
Use the Postgresql 9.5.25 and along with it comes the pgAdmin 3 installed. However, I don’t want to use the graphical interface of the database. So I go in the same folder as the pgAdmin3.exe is…