PostgreSQL Studio is a web application to manage a PostgreSQL database.
PostgreSQL Studio is a web application to manage a PostgreSQL database.
Questions tagged [postgresqlstudio]
5 questions
3
votes
2 answers
SQL WHERE AND error message
SELECT *
FROM dbo.staff
WHERE st_position = 'Supervisor' AND st_salary < AVG(st_salary);
So I'm trying to set a query that outputs a list of all supervisors that have a salary lower than average.
putting this in I get the following error.
Msg 147,…
Itay Gurvich
- 53
- 7
2
votes
1 answer
Heroku PostgreSQL Studio not finding databases
I'm making a new Django app on Heroku, and I added the "PostgreSQL Studio" add-on for running database creation scripts. It installed cleanly, it appears in the Heroku UI for each app, when I click it it's correctly trying to get to the correct…
Diane Kaplan
- 1,626
- 3
- 24
- 34
1
vote
2 answers
How to change PostgreSQL Studio's inactivity timeout?
I want to increase PostgreSQL's Studio login/session time out time. When I leave PostgreSQL Studio to idle just for some time, I get the following message:
You have been logged out due to inactivity. Please relogin or exit.
I am using PostgreSQL…
Yashasvi Raj Pant
- 1,274
- 4
- 13
- 33
0
votes
0 answers
Common Table Expression return Nothing but "command executed"
i have a user table, a pro table and a pro_users table to join : user -- many to many --> pro
i want to get the number of users, the number of pro joined to user AND the sum of user+member (this seams not relevant but it's just for testing)
i have…
Nils
- 307
- 3
- 10
-2
votes
2 answers
sqlite3.OperationalError: near "(": syntax error Python " SQL Lite
I have a small problem with a piece of code, I copied it from a web, but I have the following error:
sqlite3.OperationalError: near "(": syntax error
The code is the following:
# Import required modules
import csv
import sqlite3
# Connecting to…
AGS
- 1
- 3