Skip to content

serdnam/postgres-js-json-behavior

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Postgres.js json behavior

This repo is a demo of how the postgres package handles stringified input for JSON/JSONB columns, and how it compares to the pg package.

Test table

When using stringified objects as parameters to JSON/JSONB columns, pg properly sets these in JSON and JSONB columns as objects. However, postgres instead sets these as JSON/JSONB strings, which means things like the ->> and -> operators do not work properly.

-> and ->> operators

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published