What to Prepare
- pg_dump output files
- Custom format or SQL format
- Schema and data included
PostgreSQL is a powerful open-source relational database system known for its reliability, feature richness, and standards compliance.
Why Agent Required
PostgreSQL databases run on servers that typically cannot directly upload data to the web. The DataMeans Agent connects securely to your PostgreSQL environment for extraction.
What You Can Extract
- PostgreSQL 9.x, 10, 11, 12, 13, 14, 15, 16
- Tables, views, and materialized views
- Indexes and constraints
- Stored procedures and functions (documentation)
- Partitioned tables
What You Get Out
DataMeans extracts your data into multiple modern formats:
| Output | Description |
|---|---|
csv/{TableName}.csv | One CSV file per table with all row data |
xlsx/{TableName}.xlsx | Excel workbook per table |
xls/{TableName}.xls | Legacy Excel format per table |
json/{TableName}.json | JSON array of records per table |
json/{TableName}.jsonl | Newline-delimited JSON (streaming-friendly) |
postgres.sql | PostgreSQL CREATE TABLE + INSERT statements |
schema/schema-graph.json | Relationship graph for visualization |
schema/er-model.json | ER model for diagram tools |
report.json | Structured extraction report |
report.md | Human-readable extraction summary |
How It Works
Agent availability: The DataMeans Agent is currently in development and not yet available for download. The steps below describe the planned workflow. To get notified when PostgreSQL support launches, reach out via our About page.
- Download and install the DataMeans Agent on a system with PostgreSQL access
- Configure PostgreSQL connection credentials
- Select schemas and tables to extract
- The Agent extracts and uploads securely to DataMeans
- Review and download your converted data
Planned Support
- Full schema extraction
- Complete data extraction
- Type mapping preservation
- Foreign key relationship detection
- Large table streaming
Known Limitations
- Requires DataMeans Agent installation
- Stored procedures documented but may need adjustment
Overview
Documentation coming soon.
This article will contain vendor-neutral technical documentation about the PostgreSQL database format, including:
- History and background
- File format specifications
- Data types and structures
- Version differences
- Technical references
To learn how to use this format with DataMeans, see the User Guide.
Not available for hosted uploads. This system is read over a direct database connection by the DataMeans Agent, which is still in development. Contact us to plan a migration.
Can I convert PostgreSQL databases with DataMeans today?
Not yet. PostgreSQL is not available for self-serve upload, and support is still in development. Get in touch and we'll tell you where it stands and help plan the migration.
What will DataMeans convert PostgreSQL databases to?
Once PostgreSQL is available, exports will match every other system we support: clean CSV, Excel, JSON & SQL, one file per table, with a structured report of exactly what was extracted.
Is my data secure?
Yes. Your files are encrypted in transit and at rest, and are automatically deleted once your conversion is complete. Your data is never sold, shared, or used for anything else.