Questions tagged as 'postgresql'

Tagged questions
2
answers

Add column to a table already used by a program, could it damage the operation of it?

I have a PostgreSQL database that is used for an application developed in Delphi , but now I will have to use the same database for a new application that will be developed in Java , I need some columns that do not yet exist in some tables al...
asked by 26.05.2017 / 13:12
2
answers

Search for the name and the CPF of doctors who have appointments with all patients

In postgres, how to find the name and the CPF of doctors who have appointments with all patients? Keys: Patient: patient_id Doctor: medical id query: patient_id, medical_id     
asked by 29.06.2017 / 07:55
1
answer

Error while trying to set the MissingSchemaAction property of NpgsqlDataAdapter [closed]

I'm trying to set the MissingSchemaAction property of a NpgsqlDataAdapter object, but Visual Studio is complaining that the property does not exist. I looked at the github project and saw that NpgsqlDataAdapter inherits...
asked by 03.06.2016 / 00:32
2
answers

MD5 is good enough?

I'm working on a legacy system, which has a database with some 5 years of cumulative records without any normalization. Among other things, its purpose is to allow users to write and post posts in the same style of Twitter, but without the limit...
asked by 25.06.2016 / 14:01
1
answer

Create Postgres Numeric Field in Laravel 5.1

I need to create a field of type numeric existing in postgres using migrations of laravel, can someone tell me how to do it? I tried this but did not rotate: public function up() { Schema::create('complementos', function (Bluep...
asked by 14.04.2016 / 21:11
3
answers

Problem saving accent with Entity Framework and PostgreSQL

I need to migrate a system with SQLSERVER database to a PostGreSQL 9.3. I have never worked with PostGre before so I'm using Entity Framework 6 with model-first to make the process easier. The migration application is being developed in WPF. My...
asked by 28.06.2016 / 22:23
2
answers

Is it possible to store user inputs by Scanner Class in a database?

IhaveanapplicationmadeinJava,andIneedtostoretheuser'scadastralinformationinthedatabase:cpf,password,name,address,phoneSystem.out.println("Digite seu CPF"); cpf = ler.nextLine(); System.out.println("Senha: "); senha = ler.nextLine();...
asked by 29.06.2016 / 16:07
2
answers

Attribute Type for PostgreSQL oid column with EF6

What kind of attribute should I use to represent a column type oid of PostgreSQL with Entity Framework 6 Code-First? Remembering that PostgreSQL's oid type is for storing files.     
asked by 24.05.2016 / 16:27
1
answer

PostgreSQL many processes

I have PostgreSQL installed on a machine where a system runs, and throughout the day several processes with postgres.exe appear and consume machine resources. In moments it has more than 100 instances of these processes. Any suggestion...
asked by 09.06.2016 / 15:39
1
answer

PostgreSQL Unilateral Replication

I have two servers. One is solely for testing purposes. The other is for production itself. I need the test database to contain the same data as the production database. I can not do a mirroring, since if I do this, changes to the test server wi...
asked by 30.01.2015 / 20:09