Questions tagged as 'postgresql'

Tagged questions
0
answers

Postgree Backup Restore

When I restore a backup in Postgree's "pgadmin", if the database tables contain records, it gives error. Is there any way I can create a backup and at the time of restoration, do I inform that I want to erase the data from the tables and rest...
asked by 10.01.2018 / 12:38
1
answer

Get insert ID after pg_query ()

I'm using php and postgres in a web system, I have a form that I'm saving by doing the insert using pg_query, however, I'd like to get the id of the new record after inserting, but I'm not getting it, or it returns null or false . What I've alre...
asked by 19.12.2017 / 02:47
1
answer

Select the value of a field depending on a date

I have a table with the fields DT_FIMCALCULO, VL_DEPREREVVIDAUTILACUMULADA and CD_SEQUENCIALBEM. And for each CD_SEQUENCIALBEM I have several DT_FIMCALCULO each with a different VL_DEPREREVVIDAUTILACUMULADA. I want to select the VL_DEPREREVVI...
asked by 19.12.2017 / 13:19
1
answer

Apache tooltips to develop in php with Postgresql

Well, I want to develop in php, so I need to install a tool that will make my pc turn half the server, as everyone knows there are several tools to download such as: XAMP, WAMP, EASYPHP etc. All of these support MYSQL DBMS. I would like to kn...
asked by 20.12.2016 / 19:11
0
answers

psql: FATAL: Peer authentication failed for user "postgres"

Good afternoon, I've been studying the database for about three days. After completing the installation of postgres, I executed the command as below in msdos: psql Soon after the password was requested, and unexpectedly, this error me...
asked by 18.12.2017 / 15:10
1
answer

Problem reloading table

I'm having the following problem, on first run my DefaultTableModel loads normally as can be seen below in red: Aftermakingaregistration,changeordeletiononce,thetableupdatesnormally,butwhenIruntheseoperationsthesecondtimeon,Igetthefollowinge...
asked by 02.01.2018 / 03:46
1
answer

PostgreSQL Update

I have a question, a customer informed that there was an error in the registration of his products, and the employees registered the cost price as the price and vice versa. Would I have to run an update from PostgreSQL , changing cost prices...
asked by 20.12.2017 / 05:30
0
answers

Could not find driver

I need a help with this error, I've already done the installation and everything is ok, but I still continue to show that I need the drive, I used Brew to install Drive.     
asked by 29.11.2017 / 20:03
2
answers

search with select in database with repeated records

I'm doing a select in my bank, that is, Postgres , and there are more records coming .. For example, id_pessoa comes a 10 more record than it should come .. SELECT pac.cns, pac.cns_responsavel, pac.cpf_responsavel,...
asked by 05.12.2017 / 02:18
1
answer

Postgresql Regular Expressions

Personal speech, I need some help I'm trying to make a trigger in postgresql that checks if the format of a new data being inserted into a table is in a certain format, in this case the phone format. I need the new phone to be inserted in...
asked by 07.12.2017 / 15:47