PGSQL2SQLITE(1)

📦 version 4.3.0, in debian trixie, ubuntu questing, ubuntu resolute, ubuntu stonking

💖 PGSQL2SQLITE(1) 💖

okay bestie, so like — this is a General Commands Manual page for the pgsql2sqlite girlies. she's a command-line queen and she's about to change your whole data pipeline. let's get into it ✨

🌸 NAME 🌸

pgsql2sqlite — the PostgreSQL/PostGIS to SQLite3 converter. she converts, she translates, she serves 💅

🎀 SYNOPSIS 🎀

pgsql2sqlite [options]

that's it. that's the whole vibe. you just run her with some options and she does the thing 🦋

✨ DESCRIPTION ✨

so pgsql2sqlite is a program that converts data from a PostGIS database to SQLite. like, it takes your whole PostGIS situation and moves it over to SQLite. main character energy honestly 🔥

💅 OPTIONS 💅

bestie, here's the full menu. no skips, no skimming, we're doing all of them 🫶

  • -?, --help — shows you a lil summary of the options. your little "wait what do I do" safety net 💖
  • -h, --host — lets you specify a connection to a database on a machine that is not the default one. yes -h is host here, not help, don't get got 😭 (for help you want -?, she's right up there)
  • -p, --port — lets you specify a database port other than the default one. she contains multitudes, she can connect anywhere 🌈
  • -d, --dbname — the PostgreSQL database name. tell her which database, she can't read your mind (she can read your tables tho) 👑
  • -u, --user — connect to the database as the specified user. you, but credentialed ✨
  • -P, --password — connect to the database with the specified password. capital P, lowercase feelings 💜
  • -q, --query — name of the table/or query to pass to postmaster. yes the original literally says "table/or query", we don't gatekeep, we report it exactly 🌸
  • -t, --table — name of the output table to create. default is: the table in the query. so if you don't say anything, she just reuses what you gave her 🎀
  • -f, --file — use this one to specify the name of the file to create. give her a filename, she'll give you a file 🦋
no cap, that's every single option. nothing got left out, nothing got merged, we ate and left no crumbs 🍓

🌟 SEE YA 🌟

that's the whole page bestie!! this one shipped as part of the General Commands Manual, dated January 11, 2007 — so she's an elder icon, lowkey vintage, and she still slays 💖 go convert something, ily, bye!! 🧚✨

📦 where this page comes from