Postgres Pro
Downloads
Home   >   mailing lists

Re: Permissions pg_dump / import - Mailing list pgsql-general

From Patrick B
Subject Re: Permissions pg_dump / import
Date
Msg-id CAJNY3isNnOQu3mYSu1x1-we5M+6zG6d_spfx3x2Q1RSgquNi3A@mail.gmail.com
Whole thread Raw
In response to Re: Permissions pg_dump / import  ("Ilya Kazakevich" <Ilya.Kazakevich@JetBrains.com>)
Responses Re: Permissions pg_dump / import  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view


2016-08-18 10:30 GMT+12:00 Ilya Kazakevich <Ilya.Kazakevich@jetbrains.com>:

>> Owned by: public.accounts.id 

This is  not owner but table this sequence depends on. See http://stackoverflow.com/questions/6941043/get-table-and-column-owning-a-sequence

 

Use query provided on SO to get real owner

 


Thanks guys... the "--no-owner" option helped a lot.

Cheers
Patrick 

pgsql-general by date:

Previous
From: Branden Visser
Date:
Subject: Re: Re: Easiest way to compare the results of two queries row by row and column by column
Next
From: James Sewell
Date:
Subject: Re: Critical failure of standby