Questions tagged as 'postgresql'

Tagged questions
1
answer

connect other users to the database?

with my group we are working rather learning to work with rails and postgresql, the project was uploaded to github, they downloaded it but when starting the server (rails s) it appears that they do not have user permission in the database ....
asked by 08.12.2016 / 17:13
2
answers

How can I view the records of a database in Heroku?

After doing deploy to my application, how can I see the records of the BD% tables postgresql in Heroku ?     
asked by 17.01.2017 / 20:22
2
answers

postgres duplicate results in multiple inner join

I have a db in postgres with the following structure. tbl_predio =========== predio_id predio_nombre tbl_propietario ============== propietario_id propietario_nombre propietario_idpredio tbl_linderos =========== lindero_id lindero_nombre lin...
asked by 24.08.2016 / 16:08
1
answer

Error in using the COPY command

Good evening Community: I try to execute the following statement in PostgreSQL: COPY ad_alert (ad_alert_id, ad_client_id, ad_org_id, isactive) FROM stdin; 100 0 0 N And it throws me an error at or n...
asked by 09.11.2016 / 04:16
1
answer

relational database DER

Hi, I have a question with databases of an application that I am doing I am just going through the DER and I have a doubt the matter is: A user can have many channels from 1 to N a user can be subscribed to many channels and the channel can h...
asked by 01.07.2016 / 17:22
2
answers

I have a project with several app and it is giving me "ProgrammingError: relation" auth_user "does not exist»

I have a project with several app and you are giving me this error    django.db.utils.ProgrammingError: relation "auth_user" does not exist I've already tried putting    python manage.py migrate       python manage.py makemigrate...
asked by 24.05.2016 / 19:27
3
answers

How can I group by day and transpose output of a query in postgresql

I have a problem, I have tried to create a query that adds up the total values of a sensor grouped by day. I have tried a thousand ways and I can not, someone can help me? A small example of the data I have: Day value cod_sensor hour 06/12...
asked by 16.06.2016 / 05:45
0
answers

Restore Postgres Database

I have an application in c # I want to make the Backup and Restore from the same application in a postgres database, but here are several questions, for this I will use the command line. Backup ok, now when doing the restoration it can be do...
asked by 28.12.2018 / 06:59
0
answers

Compare that a dates in timestamptz format, PostgreSQL, Sequelize

I'm having problems comparing two dates in timestamptz, I have a table with a field expiration date and I need to compare, that a date is not greater than the expiration date in the table, I'm using Sequelize let ahora = new Date(); function v...
asked by 24.12.2018 / 20:32
1
answer

Perform search by date in a bd on asp.net

I'm doing a web in ASP.NET MVC 5 that shows a list of people, currently only shows the ones that are in that day, but since the bd stores every day I want to create a view that is history style that they put the day that they want to show and th...
asked by 19.12.2018 / 18:36