> > > > pg_dump --where "bar:created_at >= 2018-05-01'" > > I am wondering how this works at parsing if the table name, or one of > the columns includes a colon character :) >
The proposed patch will handle quoted identifiers. E.g. the following will work just fine: pg_dump --where 'table:"column:with:colons" = 5' Note the use of single quotes in the shell, and then double quotes in the WHERE clause. There are also many other options for quoting in the shell, of course. > Please don't top-post on the PostgreSQL lists. See < http://idallen.com/topposting.html> Sorry. Thanks for the reminder.
