Postgresql Questions

I am trying to make a jsonpath request on a postgresql with laravel/pdo. here is what i need to archieve. select i.id as id,

I have two tables that i want to join. it works without where conditions. after adding where conditions, i got syntax error near a

I'm playing with an app on heroku. it uses heroku postgresql but i have trouble inserting data to it. the code looks as follows:

I'm using the

I have a simple query that is designed to summarize total_miles based on a group by aggregation of other columns:

Postgresql question: i have two tables. table 1 has item, color, and size for all items in the store. table 2 is a pricing list and has item,

I'm not used to query sentences and this one is a bit tricky, i don't know even if it is possible (at least with just a single sql query) or if i

I have the following sql code select (count(*) filter (where has_a)) as count_a, count(*) as total_count, process_date from(select

I want to use if statement in insertion. insert into <table_name>(<columns>) values (if not exists

I am trying to unpivot a table with postgresql as described here. my problem is that i

I am pulling some data from an api and i want to store it in my django model. the data is a baseball inning and then runs scored that inning and

I have a table with standard columns where i want to perform regular inserts. but one of the columns is of type

I have this query : select companies.display_name, companies.pay_schedule_id, pay_schedule_periods.schedule_id,

My repository interfaces: songsrepository: public

I wanted to perform an operation where i would like to delete all the rows(but not to drop the table) in postgres and update with new rows in it.

I have a database for a job advertisement web application for an assignment at university. i have a lot of enumeration values in database such as

In my database i have the following table table "public.session" column | type | modifiers

I have the following table, with these columns first_name

I am in the process of doing export and import with postgres database. i had used the following command to take the backup of

I have a table like that id name

I have the following table: filters

I am considering log-shipping of write ahead logs

I am trying to copy a list of csv files into postgres using psycopg2's

I'm working on exporting resultset data from remote postgresql db to my local machine using psycopg2. i

I have a db connection in a js file

I am using expressjs & postgresql how to get parameter after query result in expressjs outside function this is my code

This is very basic, and should work.. but doesn't. so first my models: const conversation = sequelize.define('conversation', {

So what i want to do is to have 2 docker container running(mongodb and postgres) both of these are working. now what i want to do is to create 2

Select coalesce(a.task_id,b.task_id) as task_id,b.task_name as name from table_a as a full outer join table_b as b on a.task_id =

I have a query for multiple searches, the problem is with one of them, i get a correct result from it, but in combination with the rest, i get the

I am working on a web app where i needed to update the postgres(12) database. i am using flask-migrate for the purpose. i have tried to

I am processing a post request with nodejs on heroku and trying to insert the json into a postgres db. const client = await

I'm working on caching strategies for an application that uses knex.js for all sql related stuff. is there a way to intercept the query to check

My app is running nodejs 10.16 and sequelizejs 5.7 with postgresql 11. the initial connection is setup as: const sql =

I try to do a full text search, but i got stuck in a error. migration: public function up() {

I am trying to select a single item from a collection in my database using knex.js, but getting the error column reference "id" is

I am creating a database migration using knex (v0.19.5) and postgresql (v10.1) but when i try to set the default value to a text

I am not able to understand the response for api in laravel, it is confusing. i expect this output {

Test=# select count(id) from person' test'#

So, i am new to postgresql. my data is as follows: product wknum sales hammer 1 17 hammer 2 20 hammer 3 17 hammer 4 10

I have a postgresql database hosted on heroku which is throwing me this error that i can't wrap my head around. create table people

I have a table in postgres with timestamps: timestamp 2022-01-01 00:52:53 2022-01-01 00:57:12 ... 2022-02-13 11:00:31 2022-02-13

I have for me hard but for you very easy problem.i have jobs table and users table and i want to fetch users jobs count from database.

I recently changed the way my application connects to my postgresql database to add the

I want to select distinct name and number from a table and show it to the drop down box, then save. how can i do?

The model as below to store the ip address in postgres. from django.db import models from netfields import inetaddressfield,

I have an issue with my postgresql database, i'm running my app in a container. i have a custom command in my django app working minutely, when it

I have question regarding ponyorm and many-to-many relationship. i'm using python3.7, ponyorm and postgresql db. setup: i have two schemas

I get an econnrefused when trying to connect to a postgres server in docker from a nodejs app in docker when running both via docker-compose.

I am trying to add bigint support within my library,

I'm getting failed when building app 403 forbidden, how can i resolve this? i already search for some solution but isn't works. maybe i get wrong

I tried to connect postgresql and laravel i can see all data on pgadmin. but i can't connect the postgresql on laravel project please help me

Can you give an idea? i have two tables in to postgresql db. the are filled with recods by two separate csv files. but the records of the first

I've created a public key and stored it in my database. now i'm trying to insert encrypted data that is encrypted using the public key.

How to append a list of json filed in nodejs sequelize database: postgres i have one model field like that

Trouble with formatting using to_char extract (quarter from reviewedon) as quarter returns 4 i need it to display as

I have a little issue with a sql query. so. i have three tables: artists, albums and songs.

I have these tables albums (id integer, name text, year text) songs (id integer, title text, year text, performer text,

I want to join some of tables and getting the data to display into datatables, i'm recently using yajra datatables. here list of tables

I have a postgres table with a field requirements (json field). i need to count the not null keys in the json. what would be the best approach?

I am learning how to use sequelize orm in nodejs and save data in postgres database. my goal is to insert user data into

I have a postgres datbase with a node backend. let hash = bcrypt.hashsync("mypass", 10); try { const querystring = `

I'm using nodejs & sequelize for a school project and i'm struggling on making associations w/ sequelize work. i tried a couple of things

I'm quite new on coding, i am using nestjs to create an app along with postegresql whenever i try to update something i get an error. i

I am retrieving below data from postgres using typeorm and i want to filter this data: [{ "corporateid": 1001, "customerdetail":

Loopback has easy way to deal with database migrations, which differs from the method that uses, for example, knex.js. in the

So i need to deploy a google cloud function to make a select request on a postgresql database (cloud sql). i need to use the pg module, then i

I need to insert data in to my postgresql via db-migrate for my serverless app. so i have 4 table and each table has it's own csv data. due to the

In my node.js app using sequelize with a postgresql database i have defined three models: users, baskets, and items. the users model has many

So i'm developing a flutter project that interact with postgresql database with dart and i have a problem with the connection between postgresql

I'm writing some jest tests for a node/postgres web app. here's the fixtures helper file: /*eslint no-console: ["error",

I am new to sql in general, hence this problem is a little tricky to me. i have a table like the example below: input values:

I am using postgresql and windows. i have an sql query issue for which i need some help. the table diagram:

I am using postgresql and windows. i have column data that looks like this:

I want to deploy my laravel app in ubuntu server 18 lts. so i have install nginx postgres php. but when i try to do php artisan

I want to display and edit data from a existing postgresql database in an angular web application. i am completely new to angular and stuff. i

I have a large sql query that i'd like to move into a .sql file and then import and execute using knex.raw(). so i have

I want to use split_part inside laravel. my code

I have a complex query stored in an sql file and i would like to reuse it for various routes but change up the where clause depending on the

I have this script, that consumes a soap xml, makes it a json, and use it to load data on a postgresql db for grafana. on my main script,

I have 2 tables in my schema: 1 - covid_data (relevant columns: country, year, week, cases). data example:

I am trying to make a connection with postgresql 12 for laravel framework. i use laravel 5.8 version. when i try to login a user by using

I have my web application and i am having statistics about my users in json type column. for example: {'current': {'friends': 5, 'wins': 2,

I'm having issues setting up passport authentication with my server. i've used passportjs before but with mongodb. i'm currently trying to setup

My db looks like this

I have an array. can i send the values ​​in an array with one query and get a separate response for all arrays ...? $regions:

I'm started to write tests in laravel. my application works, i can login, run migrations, but when i'm trying to test the login, i'm getting the

I'm writing a function to dynamically create insert/update/select queries for postgresql database using psycopg2 library. i've been trying

I'm creating a reactive form in angular to register some devices. in this form i ask for a serial number, and i want to check if this serial

I have a column kid_ages which is integer[]. when migrating, i get the following error:

I'm extracting some data from the database, to use it in my nodejs app. i'm using node-postgres to connect to the db

I have in my module datetimefield: class pairs(models.model): id = models.autofield(primary_key=true) timestamp =

I'm working on a node.js single-page web application where i wanna use mvc. on my back-end, i'm using postgres database to store data that will be

I have written a backend app with express js to retrieve info from a database through get requests from an api endpoint. the query that i have

I am beginning to build out the user authentication part of my application and i am using postgresql as my database. i have a table set up in pg

I want to make charts in my laravel application and i want to show how many posts was created in each month so i need a sort of api like below

So i'm trying to convolute multiple queries and form the result as [ { heading: 'test', subheading:

So i'm trying to inner join multiple tables in order to bind jsonb with a name. but i'm getting this error. error: invalid

I am trying to configure knexfile in typescript. i created knexfile.ts with knex init -x ts: const

[ {"id":4,"sum":19}, {"id":3,"sum":9}, {"id":6,"sum":32}, {"id":2,"sum":32} ] i'm trying this, but it finds