Questions tagged as 'pgadmin'

1
answer

Swapping UTF8 for SQL_ASCII PgAdmin

Good afternoon! I need to know if it is possible for me to change my database's enconding from utf8 to SQL_ASCII, without deleting and re-creating the database! The problem that is happening is that my bank is set with Unicode UTF-8 and the s...
asked by 06.09.2018 / 15:38
1
answer

Purpose of the name of a foreign key

I'm creating tables for a system I'm developing and by entering the add foreign key part through the PostgreSQL 9.3.17 interface I noticed that it has the nome field to identify this key, I never paid much attention to it and alway...
asked by 01.08.2018 / 19:36
0
answers

Error due to cancel sale in POSTGRESQL

Good afternoon, I'm implementing a sell rebate function that is as follows: CREATE OR REPLACE FUNCTION estorna_venda(p_id_venda INTEGER) RETURNS VARCHAR AS $BODY$ DECLARE v_id_prod INTEGER; DECLARE v_prod_qtd INTEGER; DECLARE v_contador INTEG...
asked by 18.05.2018 / 21:20
0
answers

Different formatting by data in Database in Geoserver

I have a DB in pgAdmin and a table with the name: "description" I can only have 2 fields: "car" or "bike", in geoserver I configured it and it works: <Label> <ogc:PropertyName>descricao</ogc:PropertyName> </Label> <...
asked by 01.05.2018 / 00:41
0
answers

PgAdmin4 - Data Output empty

I installed PgAdmin 4 on my machine with windows 10 64bit, I configured the server, but when I open a table the query seems to execute normally, but the Data Output tab does not show anything, neither columns nor data, everything is in white....
asked by 06.02.2017 / 13:47
0
answers

Postgre error trying to access externally

I'm using NO-IP to connect to an internal server in my office. I have already freed port 5432 on the machine firewall and also configured the pg_hba.conf and postgresql.conf files (I will leave the 2 here). I tried the door on insert the link d...
asked by 01.02.2017 / 07:06
1
answer

How do I enable PostGresql on the 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 installed it in WHM and enabled the configuration, however the option for me to create the b...
asked by 10.04.2018 / 22:00