> ## Content Index
> Fetch the complete content index at: https://til.codes/llms.txt
> Use this file to discover other available public pages before exploring further.

# Dump PostgreSQL without owner and privileges
- URL: https://til.codes/dump-postgresql-without-owner-and-privileges/
- Published: 2015-12-29T16:29:34.000Z
- Updated: 2015-12-29T16:29:34.000Z
- Author: Manu Ajith
- Tags: postgres, postgresql, database, #Import 2024-07-13 21:01

If you ever wanted to dump your postgres development database without the owner and the privileges, then you just need to run the following command:

```
pg_dump database_name -O -x > output_file

```