Questions tagged as 'postgresql'

Tagged questions
1
answer

How to create a Server in PostgreSQL with port other than 5432?

Is it possible to create a server inside the Postgresql database with a port other than 5432? It is possible to have  Server1: Postgresql on port 5432 and  Server2: Test on port 5433 ??     
asked by 06.10.2017 / 18:49
1
answer

Create a procedure in PostGreSql

I have created a database in PostGreSql of Equipment Allocation where one or many Equipment can be Allocated by one or many Sectors. That is, I have 3 tables in this relation: One is the Table Sector with columns (CODE AND NAME): CREATE TABLE...
asked by 04.09.2017 / 21:01
1
answer

Problem writing ComboBox data in Postgresql

First is the code of the bank I'm using: CREATE TABLE perguntas ( cod_pergunta SERIAL PRIMARY KEY NOT NULL, pergunta VARCHAR(500), opcao_um VARCHAR(500), opcao_dois VARCHAR(500), opcao_tres VARCHAR(500), opcao_quatro V...
asked by 30.08.2017 / 15:12
1
answer

Error executing a query with npgsql + dapper in postgresql

I can get my "user" object that has a "Login and Password" inside it, and when I run the function through my ORM, I get the following error message:    {"42883: operator does not exist: @ character varying"}. Could anyone tell me what mig...
asked by 30.08.2017 / 07:53
1
answer

PGbouncer does not connect via service on windows

I installed pgbouncer as a service on windows 10 using: pgbouncer.exe --regservice <pgbouncer.ini> Placing the ini path and from the folder where the pgbouncer exe is. The service is installed normally and I can start it by the wind...
asked by 27.06.2017 / 21:45
1
answer

How to return pilot names in SQL table?

I have the following tables below, and would like to return only the name of the riders who have never participated in a race in a Brazilian circuit in the country brasil . Table Structure: PAIS (id, sigla, nome) EQUIPE (id, nome, pa...
asked by 14.07.2017 / 16:22
2
answers

Remove double quotation marks in codeigniter query builder

I'm using the Codeigniter framework and every time I create a select with query builder of them, it puts double quotes in all columns and tables. Ex: SELECT "ID", "NAME" FROM "STUDENT" This gives me a problem because I use 2 connections to...
asked by 06.06.2017 / 14:04
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
3
answers

Problem when ordering sql with orderby Date in postgresql

I have the following Query that results in joining the total sum of an account and the plots select sum(total) as total, datavencimento from ( select sum (con_valoraserpago) as total, to_char(con_datavencimento...
asked by 09.08.2017 / 01:25
1
answer

Date insertion in PostgreSQL

I would like to know how to configure Postgre to accept date entries as follows: "12122016" . I know that with the same "spelling" it is possible with YMD but I would like to know how to configure it to accept it. Thanks in advance...
asked by 03.03.2017 / 19:14