Content Deep Dive
Bringing psql’s \d to your web browser
Blog post from Neon
Post Details
Company
Date Published
Author
George MacKerron
Word Count
1,425
Language
English
Hacker News Points
76
Summary
Neon's SQL Editor now supports Postgres's introspection commands such as \d and others. These commands were originally implemented in the C code for psql client but have been translated into JavaScript to enable their use within web browsers. The implementation includes reimplementing some C and Postgres functions, writing examples of all different psql introspection commands, and a test script that compares their results in psql to the results generated by the new JavaScript code. This feature allows users to list or describe things held in Postgres databases directly from their web browser's SQL Editor.