"heroku db: pull --exclude table_name" How to exclude more than one table?

I cannot find anywhere how to use "-exclude". When i try this code

heroku help db:pull 

I get this:

 Usage: heroku db:pull [DATABASE_URL] pull heroku data down into your local database DATABASE_URL should reference your local database. if not specified, it will be guessed from config/database.yml -c, --chunksize SIZE # specify the number of rows to send in each batch -d, --debug # enable debugging output -e, --exclude TABLES # exclude the specified tables from the pull -f, --filter REGEX # only pull certain tables -r, --resume FILE # resume transfer described by a .dat file -t, --tables TABLES # only pull the specified tables 

ok I understand how to use "-e" with one table, but I want to exclude more than one table. He does not work:

 heroku db:pull -e users, versions 
+4
source share
3 answers

It works for me

 heroku db:pull -e "stats admins" --app APP_NAME 
+7
source

I just used

heroku pg:pull DATABASE_URL LOCAL_DB --exclude-table-data TABLE_NAME --app APP_NAME

UPDATE: to exclude multiple tables, try

heroku pg:pull DATABASE_URL LOCAL_DB --exclude-table-data TABLE_1_NAME; --exclude-table-data TABLE_2_NAME --app APP_NAME

try heroku pg: pull --help to get full documentation

0
source

From the documents "Use"; for separation of names "

heroku pg:pull [DATABASE] --exclude-table-data "[FIRST_TABLE_NAME];[SECOND_TABLE_NAME]" --app [APP_NAME]

0
source

All Articles