I have a function in PostgreSQL that takes 6 values, the first one character varying , the next one an integer and the remaining 4 are of type numeric .
I call it from Java in the following way:
preStmt=con.prepareStatement(...
I need to make queries to the database ( postgresql ) but the tables I want to consult were created by pandas so I do not have a model to refer to, how do I do queries without models?
Well I mean, I have a database in SQL SERVER called SIELAB and another database in PostgreSQL called reservations , I managed to make the connection correctly and I have already managed to execute a SELECT query from a stored procedure...
I want to write the result of several SQL queries that are dependent on a table res[ids] .
for i, ids in enumerate(self.res['ids']):
print ids
cur.execute("""--- hashtag describiendo los grupos de subscrib...
I need to form the json in this way in PostgreSQL.
ubi_json json;
FOR i IN 0..7 LOOP
ubi_json = ubi_json || to_json('valor',i);
END LOOP;
Error comes out:
Error : no existe la función to_json(unknown, integer)
I need this:...
I have this query
select distinct p.nombre,
p.total,
p.clie_id
from(select cli.nombre as nombre,
cli.clie_id,
cue.cuen_id as cuenta,
count(cue.clie_id) over(partition by cli.clie_id) as total...
I am implementing a larvel project, this already has a populated database. Now I need to deploy this project in Heroku but I can not make the migration from my .sql file to postgres Heroku. I have tried with the documentation but the single inst...
Objective. I have to develop a project with Django and I want it to have the following characteristic: for each company or client (whether company or not) that uses my system, I want a database to be created independent.
Basically what I wa...
I have to build two functions to use in the creation of roles and in assigning a role to a group according to its category in postgresql.
Here's the code: The first function is to create a user and call my second function that will assign t...
I'm going to upload a Rails project to Heroku so the project is in Postgres but when I try it in development (Not in production) I get this error:
PG :: ConnectionBad
fe_sendauth: no password supplied
In my database file I have it like this:...