Questions tagged as 'postgresql'

Tagged questions
1
answer

a group of students can not use that classroom if it is already reserved at that time [duplicated]

I have a problem I do not know how to design the solution. A group of students can not use that classroom if it is already reserved at that time. For example, you can not assign a group to a classroom that is already occupied with a specific...
asked by 04.05.2018 / 09:30
1
answer

Can you make an app that connects to a postgresql database? [closed]

Hi, I would like to know if I can make a connection to a postgresql database in the app I am doing with android studio. Thanks     
asked by 13.09.2017 / 10:01
1
answer

PSQLException: syntax error on or near "user"

I have this error when using PreparedStatements to insert a User into a table in Postgresql called " user ", this action is carried out by crushing a button with the help of a PostgresHelper: PostgresHelper client = new Pos...
asked by 17.10.2018 / 19:25
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
2
answers

Make insert in table if there is no POSTGRESQL record

I am trying to make an insert in a table but only insert IF the record I want to enter does not exist, in the case that there is already doing nothing. I've tried it this way, I've just registered the names but the insert is as is: INSERT I...
asked by 14.11.2018 / 17:08
1
answer

Get the key of a JSON in PHP? (Not the value but the key)

I have a JSON Object that sent it from android to PHP it's similar to this {"1":"insert 1", "2":"insert 2", "3":"insert 3" } the number is the id of the record and the insert is a sql instruction that is executed to save values in a BASE n...
asked by 17.09.2018 / 18:52
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

Consultation with join brings me more records than expected

I need to make a join between 2 tables, I have the person table which contains 58422 records, and I have the evaluation table which contains 59175 records what I need is that it only brings me to join the total of the person table and not that o...
asked by 08.05.2018 / 16:15
2
answers

PostgreSQL foreign key violation

Good hope you are very well, I come to you for help, you will see, I have several tables in my BD but the ones I think give me problems are the tables called "project" and "winner" , the "winner" table must have the primary key of "project...
asked by 14.03.2018 / 06:59
2
answers

Problem in consultation NOT IN

I have a problem with a query, initially very easy. I created a table control_de_stock where is the information of the stock of thousands of articles, each of them with its "id producto" . I created another table ordenes_de_ve...
asked by 04.02.2018 / 13:05