Questions tagged as 'pgadmin'

1
answer

Error creating a NOT NULL field in PGADMIN "contains null values"

I have a database already created, inside it I have a table already created. In it I need to create a field that is NOT NULL . I do everything via the graphical interface that is faster, I click on the > new column : table, giv...
asked by 01.04.2015 / 15:01
2
answers

Trigger that updates record in a table

I need to update an X table whenever there are any changes in the Y table. I have found numerous examples of how to save the changed records in the Y table, both when a record of the X table is deleted and when it is changed or inserted, but my...
asked by 11.05.2017 / 20:52
1
answer

Error connecting to PostgreSQL by pgAdmin 4

I installed pgAdmin 4 on my note with Windows 10 and I am not able to access the database.    Host name / address = /198.22.33.44   Door 5432   Maintenance Database = xxxxxx   Username = cesar_r   Password = ******   SSL mo...
asked by 30.03.2017 / 20:09
1
answer

Perform PostgreSQL Update by PgAdmin without SQL command, but by Interface

I need to change some data from my bank PostgreSQL to PgAdmin but I would like it to be straightforward through the PgAdmin interface and not through SQL commands, this is possible. For example when I want to create a new co...
asked by 16.01.2017 / 12:40
0
answers

Login page problem, redirect

It works fine, it does not let pass the credentials that are not configured. But at the time of redirecting it to the other, it does not work. session_start(); if (!empty($_POST)) { $isim = $_POST['login']; $sifre = $_POST['password']...
asked by 29.03.2018 / 00:56
1
answer

Importing XLS to PgAdmin

I'm trying to import a spreadsheet with information from a database table, but when I try to import, it gives the following message:    field 'md5' must have a value However, there are values in this field. I do not know what to do about...
asked by 10.12.2017 / 23:18
1
answer

Send 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 file in INSERT but it did not work. I do not...
asked by 09.11.2016 / 17:53
1
answer

Help with inner join: "No space left on device"

I'm not very knowledgeable in SQL programming and experience, however, I need to do a search on a PostrgeeSQL database (I'm using pgAdminIII) where I need to join two tables. create table table_new as select table.x1, table.x2, table.x3, tabl...
asked by 11.06.2016 / 21:10
1
answer

Posgresql has no role with superuser how to create one

When I went to check in postgresql it does not have any superuser like I do to change or create a superuser     
asked by 12.01.2018 / 15:30
1
answer

Connect PgAdmin via SSH Google Cloud

Good, next folks. I have a server in the Google Cloud, and I installed the postgres and everything is ok, it's working beauty, there in my machine I installed pgAdmin III and I made the configuration to connect with the bank, initially it worked...
asked by 19.08.2017 / 04:27