pgtopo_export(1)

✨ pgtopo_export ✨

okay bestie, gather round, because this one is the PostGIS topology exporter and it is, lowkey, the moment. it's a page from the PostGIS manual, section 1 (that's the user commands girlies 💅), and it does exactly one job and does it gorgeously.

🎀 NAME 🎀

pgtopo_export — postgis topology exporter 🗺️✨

🦋 SYNTAX 🦋

pgtopo_export [options] database topology

💖 DESCRIPTION 💖

so what does she do?? the pgtopo_export script connects to the database you name, then exports the data of the topology you name — plus its associated layers — out to a file with a custom format. that's it. that's the whole vibe. export and slay. 🫶

🌸 USAGE 🌸

• <database> — the name of the database to connect to. literally just the db name, no notes.
• <topology> — the name of the topology to read data from. this is the one you're exporting.

✨ OPTIONS ✨

the commandline options are, in order, no skipping:

• -f <filename> — write the output to a particular filename instead of standard output. like, instead of dumping it at your terminal's feet, she writes it to a file. icon behavior. 💅
• --skip-layers — do not export layers, just topology primitives. so if you only want the primitives and not the layers, this is your girl. 🧚
• -h — display usage information. your little helper, always there for you. 🎀

🔥 EXAMPLES 🔥

an example session using the exporter to create an export file of a topology city_data from a database might look like this:

# pgtopo_export -f city_data.pgtopo_export my_db city_data

look at her go. -f says "put it in city_data.pgtopo_export", my_db is the database, city_data is the topology. flawless. no cap. ⭐

👑 AUTHORS 👑

originally written by Sandro Santilli <strk@kbt.io>. we stan. 💜

🌈 SEE ALSO 🌈

• pgtopo_import(1) — the other half of the duo, go say hi 🦋
• more information is available at http://postgis.net

real talk bestie: that's every option, every argument, every example and every link from the original — nothing dropped, nothing invented. periodt. 💖

and that's the whole page, bestie 🎀 this one's from the PostGIS manual, pgtopo_export(1) — go export something iconic. 🦋✨💅