Re: Permissions pg_dump / import

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: Ilya Kazakevich <Ilya(dot)Kazakevich(at)jetbrains(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permissions pg_dump / import
Date: 2016-08-17 23:27:12
Message-ID: CAJNY3isNnOQu3mYSu1x1-we5M+6zG6d_spfx3x2Q1RSgquNi3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2016-08-18 10:30 GMT+12:00 Ilya Kazakevich <Ilya(dot)Kazakevich(at)jetbrains(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2016-08-17 23:32:23 Re: [GENERAL] C++ port of Postgres
Previous Message Branden Visser 2016-08-17 22:58:34 Re: Re: Easiest way to compare the results of two queries row by row and column by column