Questions tagged as 'pgadmin'

Tagged questions
1
answer

How can I enter a data in a table in pgAdmin 4?

I downloaded version 4 of pgAdmin, but when trying to enter a data, I can not find a way to do it graphically.     
asked by 24.08.2017 / 00:52
1
answer

psycopg2.OperationalError: fe_sendauth: no password supplied⁠?

It turns out that I'm trying to get my program to get data from a database generated from pgadmin, but I'm not making it happen. I'm trying to make this work: from psycopg2 import connect import dbconfig cfg=dbconfig dbname=cfg.dbname dbhos...
asked by 07.07.2017 / 22:01
1
answer

Error in using the COPY command

Good evening Community: I try to execute the following statement in PostgreSQL: COPY ad_alert (ad_alert_id, ad_client_id, ad_org_id, isactive) FROM stdin; 100 0 0 N And it throws me an error at or n...
asked by 09.11.2016 / 04:16
1
answer

Call sequence in a create table stored in a variable

Hello have the following problem: I have created a sequence in a trigger, and then dynamically instantiate it by create statements of tables in the same trigger. When I try to put NEXTVAL('secuencia') the single quotes tell me the variabl...
asked by 17.01.2018 / 21:08
0
answers

restoring database in postgresql takes a long time

I have the following problem. I generate the .backup from my database that weighs 210 megabytes. When I restore from the pgadmin 3 it takes an eternity (it's a whole afternoon or an entire night). I've even restored it from the console thinking...
asked by 27.10.2017 / 18:36
1
answer

If I uninstall pgAdmin does PostgreSQL remain installed?

I want to uninstall PgAdmin4 but I do not know if that will cause PostgreSQL to be uninstalled or if it affects my databases that I have.     
asked by 12.02.2017 / 01:50
1
answer

Error Pgadmin III Server does not listen [closed]

I just installed Pgadmin 3 (because the 4 throws me errors) then when creating a new server I get the following error:    Server does not listen The server does not accept connections: the   connection library reports could not connect to ser...
asked by 15.06.2018 / 14:34
1
answer

Generate relationships in pgAdmin 4 (Postgresql)?

I am maintaining a database in Postgresql , being sincere it is very complex and I can not understand it completely. I have searched for information to be able to generate relationships between the tables, and thus better understand the da...
asked by 13.12.2017 / 22:05
1
answer

the BD table in postgresql is not updated

Good morning, I am practicing with PHP and postgresql to do a project for the university and I have not been able to update a table in the BD for two days. I've been changing the syntax reading solutions in different forums and I do not know wha...
asked by 28.05.2017 / 12:22
0
answers

Update content databases on different servers - postgres

I have 2 database servers, one for production and the other for development. What I want to update the development data with the production. The issue is that, in development maybe I have tables that do not yet exist in production, so, I have...
asked by 13.12.2018 / 12:47