pgtopo_import(1)

✨ pgtopo_import — postgis topology importer ✨

okay bestie, welcome to pgtopo_import, part of the PostGIS crew 🫶 this is the little loader that takes your topology out of the group chat and puts it back into the database. let's get into it 💅

---

🌸 SYNTAX 🌸

pgtopo_import [options] topology

that's it, that's the whole vibe ✨

---

💖 DESCRIPTION 💖

so the pgtopo_import data loader reads an export file that was written by pgtopo_export 👑 and then it spits out an SQL script that reconstructs the topology that's inside that file. literally that's its whole job. no cap. 🌈

---

🎀 USAGE 🎀

the <topology> argument is the name you want to give to the re-created topology — and yes, it can be different from the name of the topology the export was originally made from. glow-up naming rights, you have them 💅

by default the SQL script gets written on standard output. so it just comes out, streamed, no extra files, very main character energy ✨

---

💜 OPTIONS 💜

these are the supported options 🫶

note bestie: --skip-layers and --only-layers are mutually exclusive. pick one, not both, ok? 😭

• --skip-layers — do not include layers in the output SQL script. just the topology schema. layers? not invited to this party 🙈
• --only-layers — do not include the topology schema in the output SQL script. just the layers. schema? not invited to this party 🦋
• -f <filename> — read the export file from the specified filename, rather than from standard input. so instead of piping it in, you point at it 📁
• -h — display usage information. the little help me out moment, iconic 🌸

---

⭐ EXAMPLES ⭐

an example session using the loader to create an SQL file and uploading it might look like this:

# pgtopo_import city_data < city_data.pgtopo_export | psql newdb

look at that pipe. chef's kiss. pgtopo_import makes the SQL, psql eats it into newdb. ate. 🔥

---

👑 AUTHORS 👑

originally written by Sandro Santilli <strk@kbt.io> 💖

---

🌈 SEE ALSO 🌈

• pgtopo_export(1)

more information is available at http://postgis.net 🧚

---

and that's the whole page, bestie!! this one came from the PostGIS source, and it's the pgtopo_import(1) page — go forth and reconstruct those topologies 💅✨🦋