I'm trying to create a backup from PostgreSQL database, but getting the following error: pg_dump: No matching schemas were found
I'm logged in as root and running the command
pg_dump -f db.dump --format=plain --schema=existing_schema --username=userx --host=localhost databasename
Output of \dl:
List of relations Schema | Name | Type | Owner --------+-------------------------------------+-------+------- public | existing_schema | table | userx
You can try with back slash and double quote as metioned here.
sudo -u postgres pg_dump -v Database_Name -t "\"Table_Name\""