Re: Dump table using pg_dump vs pg_restore -f

On 11/29/18 7:31 AM, Adrian Klaver wrote:
> Postgres 10.6
> 
> I am getting different output using:
> 
> pg_dump -d production -U postgres  -s -t container -f cont.sql
> 
> vs
> 
> pg_restore -s -t container -f container.sql production_112818.out
> 

> 
> In the docs:
> 
> https://www.postgresql.org/docs/10/app-pgrestore.html
> 
> I see:
> 
> "
> Note
> 
> This flag does not behave identically to the -t flag of pg_dump. There 
> is not currently any provision for wild-card matching in pg_restore, nor 
> can you include a schema name within its -t.
> "
> 
> That to me reads that the difference is for the search method for table 
> names only.
> 
> The description for:
> -t table
> 
> Includes:
> 
> "Restore definition and/or data of only the named table. ..."
> 
> That in my mind would include the PK and the table triggers.
> 
> Am I misunderstanding?
> 

Just wondering,  am I the only one seeing this issue?

Am I doing something wrong?


-- 
Adrian Klaver
adrian.klaver@aklaver.com