Questions tagged as 'postgresql'

Tagged questions
0
answers

How to create tables in Postgre with not null fields? [closed]

Good morning, gentlemen, I made my attempt to create my Postgre table this way: CREATE TABLE categoria ( codigo BIGSERIAL, nome VARCHAR(50) NOT NULL, PRIMARY KEY(codigo) ); Although the name field is like not null it is...
asked by 15.11.2017 / 12:40
1
answer

Create a ruby on rails feature list

I have been trying for a few days but I have not been able to solve my problem. I need to create a feature list for an item and then list all of them. I wish they could help me or pass me some tutorial on. Home Well I have a person's registry an...
asked by 29.04.2017 / 18:45
0
answers

Login pgAdmin 4

I installed pgAdmin 4 in Debian and when I access the login screen it asks me for email and password. I expected him to ask the user "postgres" and the password. I would like to know how to register this email to login.     
asked by 04.08.2017 / 20:39
2
answers

How to calculate total accumulated of 365 days joining two different years?

I'm trying to check the cumulative total for a certain amount, which starts in September of a year and runs through August of the following year, and then resumes. I'm doing this with a long historical series, so it would be n sums for various d...
asked by 15.02.2017 / 13:00
1
answer

Update from the comparison between two postgres tables

I have a sales table that contains the salesperson's code. But the seller's table was completely redone, with the change of id . How can I update the vendor code in the sales table from the comparison between the new vendor table and th...
asked by 19.09.2016 / 20:07
1
answer

N-to-N relationship - How to join two fields in a Postgresql record -

In an N-to-N relationship I have three tables "book", "author" and "book_autor". Being the following data and structures: tblBook: id_livro | nomelivro '1' ; 'O Cortiço' '2' ; 'O mulato' '3' ; 'Quimica Geral' tblAutor...
asked by 30.03.2016 / 16:21
1
answer

C library function in Postgresql

I'm using Visual Studio 2015 to create a function in a dll, and when I try to use it in Postgres, I get the following message:    server closed the connection unexpectedly       This probably means the server terminated abnormally       befor...
asked by 22.09.2016 / 21:31
1
answer

Inheritance PHP and Doctrine: Duplicate definition of column

Good afternoon. The following error is occurring: Error: Duplicate definition of column 'num_user' on entity 'User' in a field or discriminator column mapping. My User class extends from OwnGroup. Then the User Class mapping is as f...
asked by 26.07.2016 / 21:49
1
answer

Persistence with Doctrine does not take data from the object to the insert

I started a new project in PHP where every database is with tables and their columns with different names of classes and their attributes. With the intention of gaining in the productivity of not being renamed I decided to apply Doctrine ORM...
asked by 20.11.2015 / 21:14
1
answer

How do I restore a database from logs in postgres?

I have the database logs that I get through the pg_start_backup and pg_stop_backup commands. I would like to know how do I restore the bank through them? Thank you!     
asked by 11.09.2015 / 14:55