I just started to learn nodejs-postgres and found the pg-promise package. I read the docs and examples but I don't understand where should I put the initialization code? I using Express and I have many routes.   I have to put whole initializati...
Looking at https://github.com/vitaly-t/pg-promise/wiki/Data-Imports there's a very detailed doc on how to use it for importing.  However while that works for the demoed scenario I don't know how to apply it on my case.  When I do my web call,...
Developed by node.js. I am using pg-promise.  There is a problem with inserting the following data.  I want to insert multiple rows of data into the table below.  create table info (   id varchar(20) not null,   name varchar(20) not null,   createdat...
I'm trying to follow the performance pattern recommended by the pg-promise library author here.  Basically Vitaly recommends to do so with inserts :   var users = [['John', 23], ['Mike', 30], ['David', 18]];  // We can use...
Recently I started using pg-promise with bluebird library. I have always been nesting callback and handling err in each callback. I find that the catch statement in promise looks really neat. I am not sure if it possible to turn this code to promise...
I was searching the documentation of pg-promise specifically in the creation of the client. But I wasn't able to find the option to set the default schema to be used in the connection, it always uses public schema. How do I set it?...
I have the following query that inserts data into a many-to-many join table  INSERT INTO playlist_genre(playlist_id, genre_id) VALUES  (${playlistId}, ${genre1Id}),         (${playlistId}, ${genre2Id}),         (${playlistId}, ${genre3Id}) );   Howev...
I'm currently creating a NodeJS website using PostgreSQL via pg-promise.   I have a page with an HTML form with checkboxes to select variables to search the database for using various fields. These are then fed into a SQL query with pg-promise an...
From example where-col-in example and this answer, WHERE IN clauses should have query with parameters with following syntax  const response = await db.any('SELECT * FROM table WHERE id IN ($1:csv)', [data])   where data is an array.  Now, whe...
I am using pg-promise. i am learnner please excuse if it seems trivial to you. how can i wrtie unit test for. it errors out data is undefined. i have been making connection in js file and export that module.another js file use to query against databa...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.