Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const pg = require('pg');
- const config = {
- host: 'your-pg-server.postgres.database.azure.com',
- user: 'your-pg-login@mypgserver-20170401',
- password: '<server_admin_password>',
- database: '<name_of_database>',
- port: 5432,
- ssl: true
- };
- const client = new pg.Client(config);
- client.connect(err => {
- if (err) throw err;
- else {
- queryDatabase();
- }
- });
- function queryDatabase() {
- const query = `DELETE FROM inventory
- WHERE name ='apple'`;
- client
- .query(query)
- .then(() => {
- console.log('Delete completed succesfully!');
- })
- .catch(err => console.log(err));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement