[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_148":149},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":85,"_103":104,"_141":-5,"_142":11,"_143":17,"_144":11,"_145":-5,"_146":147},"canonicalUrl","https://hub.docker.com/r/microservices/psql/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","microservices","reponame","psql","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":58,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2018-06-18T07:59:49.567539Z","description","","is_private","last_updated","2019-11-29T23:18:28.000006Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",1211,"repository_type","star_count",1,"status","status_description","active","source","collaborator_count",0,"full_description","# _PostgreSQL_ OMG Microservice\n\n> Interact with a Postgres database.\n\n[![Open Microservice Specification Version](https://img.shields.io/badge/Open%20Microservice-1.0-477bf3.svg)](https://openmicroservices.org)\n[![Open Microservices Spectrum Chat](https://withspectrum.github.io/badge/badge.svg)](https://spectrum.chat/open-microservices)\n[![Open Microservices Code of Conduct](https://img.shields.io/badge/Contributor%20Covenant-v1.4%20adopted-ff69b4.svg)](https://github.com/oms-services/.github/blob/master/CODE_OF_CONDUCT.md)\n[![Open Microservices Commitzen](https://img.shields.io/badge/commitizen-friendly-brightgreen.svg)](http://commitizen.github.io/cz-cli/)\n[![PRs Welcome](https://img.shields.io/badge/PRs-welcome-brightgreen.svg)](http://makeapullrequest.com)\n[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](https://opensource.org/licenses/MIT)\n\n## Direct usage in [Storyscript](https://storyscript.io/):\n\n### Create table\n\nA table can be created with `createTable`:\n\n```coffee\npsql createTable table: \"books\" columns: {\n \"id\": \"serial primary key\",\n \"title\": \"varchar(100)\"\n}\n```\n\n### Insert an entry\n\n```coffee\npsql insert table: \"books\" values: {\"title\": \"Ulysses\"}\n# result: {\"id\": 1, \"title\": \"Ulysses\"}\n```\n\n### Insert multiple entries\n\n```coffee\npsql insert table: \"books\" values: [{\"title\": \"Moby Dick\"}, {\"title\": \"War and Peace\"}]\n# result: [{\"id\": 2, \"title\": \"Ulysses\"}, {\"id\": 3, \"title\": \"War and Peace\"}]\n```\n\n### Select entries\n\n- `$and` and `$or` can be used to combine queries\n- `$lt`, `$lte`, `$gt`, `$gte` and `$eq` can be used as comparison operators\n- if no comparison operators is provided, the query will match on equality\n- `columns` can be used to filter the selected fields\n\n```coffee\npsql select table: \"books\" where: {\"title\": \"Moby Dick\"}\n# result: [{\"id\": 2, \"title\": \"Moby Dick\"}]\n```\n\n```coffee\npsql select table: \"books\" where: {\"$or\": {title: \"Moby Dick\", \"id\": {\"$lt\": 2}}}\n# result: [{\"id\": 1, \"title\": \"Ulysses\"}, {\"id\": 2, \"title\": \"Moby Dick\"}]\n```\n\n```coffee\npsql select table: \"books\" columns: [\"title\"] where: {\"title\": \"Moby Dick\"}\n# result: [{\"title\": \"Moby Dick\"}]\n```\n\n### Update entries\n\n```coffee\npsql update table: \"books\" values: {\"title\": \"UPDATED\"} where: {\"id\": {\"$gt\": 2}}\n# result: [{\"id\": 3, \"title\": \"UPDATED\"}]\n```\n\nThe where query is optional, but without it _all_ columns will be updated:\n\n```coffee\npsql update table: \"books\" values: {\"title\": \"UPDATED\"}\n# result: [\n# {\"id\": 1, \"title\": \"Ulysses\"},\n# {\"id\": 2, \"title\": \"Ulysses\"},\n# {\"id\": 3, \"title\": \"War and Peace\"}\n# ]\n```\n\n### Delete entries\n\n`delete` uses a `where` select query and will return the deleted columns:\n\n```coffee\npsql delete table: \"books\" where: {\"title\": \"Moby Dick\"}\n# result: [{\"id\": 2, \"title\": \"Moby Dick\"}]\n```\n\nThe where query is optional, but without it _all_ rows will be deleted.\n\n### Drop table\n\nAn entire table can be dropped with `dropTable`:\n\n```coffee\npsql dropTable table: \"books\"\n```\n\n### Execute\n\n```storyscript\n# Storyscript\nresult = psql exec query: \"select * from my_table where name=%(username)s\" data: {\"username\": \"jill\"}\n# result is an array, with records as JSON objects inside it.\n```\n\nCurious to [learn more](https://docs.storyscript.io/)?\n\n✨🍰✨\n\n## Usage with [OMS CLI](https://www.npmjs.com/package/@microservices/oms)\n\n##### Create Table\n\n```shell\noms run createTable -a table= -a columns= -e POSTGRES_DSN=\n```\n\n##### Drop Table\n\n```shell\noms run dropTable -a table= -e POSTGRES_DSN=\n```\n\n##### Insert\n\n```shell\noms run insert -a table= -a values= -e POSTGRES_DSN=\n```\n\n##### Select\n\n```shell\noms run select -a table= -a where= -e POSTGRES_DSN=\n```\n\n##### Update\n\n```shell\noms run update -a table= -a values= -a where= -e POSTGRES_DSN=\n```\n\n##### Delete\n\n```shell\noms run delete -a table= -a where= -e POSTGRES_DSN=\n```\n\n##### Execute\n\n```shell\noms run exec -a query= -a data= -e POSTGRES_DSN=\n```\n\n## License\n\n[MIT License](https://github.com/oms-services/psql/blob/master/LICENSE).\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",996603047,"orgData",{"_86":87,"_88":89,"_90":91,"_92":29,"_93":44,"_94":44,"_95":44,"_96":44,"_97":98,"_99":44,"_100":44,"_101":44,"_102":17},"id","c759d2514c42477a8e485e68571ea128","uuid","c759d251-4c42-477a-8e48-5e68571ea128","type","organization","orgname","full_name","location","company","profile_url","date_joined","2015-03-19T21:39:27.394665Z","gravatar_url","gravatar_email","badge","is_active","recentTags",[105],{"_106":40,"_107":108,"_109":110,"_86":111,"_112":113,"_46":130,"_131":108,"_132":29,"_133":52,"_53":134,"_135":136,"_137":121,"_138":130,"_139":61,"_140":17},"content_type","creator",250118,"full_size",43798134,29362660,"images",[114],{"_115":116,"_117":118,"_119":44,"_120":121,"_122":123,"_124":125,"_126":44,"_127":-5,"_128":110,"_59":61,"_129":-5},"architecture","amd64","digest","sha256:4fd7859503ce65c69ce5a9419755743d9902a8878fcd3a618769e670b3a83168","features","last_pulled","2026-09-10T10:36:06.578654255Z","last_pushed","2019-11-29T00:25:15Z","os","linux","os_features","os_version","size","variant","2019-11-29T23:18:27.663367Z","last_updater","last_updater_username","media_type","latest","repository",5631690,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":150,"_157":158,"_146":167,"_168":11},{"_36":151,"_38":152,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":153,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":58,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":11,"_68":29,"_69":154,"_75":11,"_76":156,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":155},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_159":58,"_160":-5,"_161":-5,"_162":163},"count","next","previous","results",[164],{"_106":40,"_107":108,"_109":110,"_86":111,"_112":165,"_46":130,"_131":108,"_132":29,"_133":52,"_53":134,"_135":136,"_137":121,"_138":130,"_139":61,"_140":17},[166],{"_115":116,"_117":118,"_119":44,"_120":121,"_122":123,"_124":125,"_126":44,"_127":-5,"_128":110,"_59":61,"_129":-5},[],"canDeleteTags","actionData","errors"]

microservices/psql

Tags for microservices/psql