Postgresql Questions

I am looking for a way to return the number of rows affected by a delete clause in postgresql. the

I have tablea and it has a field of time_captured | timestamp without time zone | default now() it is being used to record when data was

I am working with c programming language and using postgres database to insert records. one of the columns of the table in the database is of type

Ideally something that will work with oracle, ms sql server, mysql and posgress.

I'm just starting with building apis, node.js, postgres so this might be a bit of a naive question.. i have noticed that when i call the update

I 'm using postgres, i created db, user, password, this is the password: password = name&[email protected] i'm using the

There is an almost identical, but not really answered question

There is a spring mvc app where the customer has the option to place an order. you can set the date and time of the order in the

What are some strategies that people have had success with for maintaining a change history for data in a fairly complex database. one of the

I am looking for a way to concatenate the strings of a field within a group by query. so for example, i have a table: id

I want to be able to connect to a postgresql database and find all of the functions for a particular schema. my thought was that i could

Phppgadmin comes with instructions for creating a reports

I want to run aws postgres aurora global database in my staging environment, but i want to stop it overnight and weekends. it seems like this

Given this directory structure: . ├── backend ├── compose.yaml └── frontend └── dockerfile.dev 2

I am a cs student that is taking his first course in databases so here i am using postgresql to create a database with the following tables:

I am struggling to understand a part of a query, how could it be valid, and whether is an expensive bad practice or not. basically i have

For college i'm doing a thesis on performance in different dbms. i have set of tables with same set of data in 5 different dbms (mysql, mariadb,

I would like to know how experienced sql users would compute a lot of counts with different conditions. i have a table [population] and a table

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