Search Postgresql Archives

Re: Permissions pg_dump / import

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Permissions pg_dump / import
From: Patrick B <patrickbakerbr@xxxxxxxxx>
Date: Thu, 18 Aug 2016 11:27:12 +1200
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <000901d1f8d7$0099edc0$01cdc940$@JetBrains.com>
References: <CAJNY3iuO9xF0C-OWLpbd+bAZsouT11_ops2uN+Gxt8HUHUhGXw@mail.gmail.com> <000901d1f8d7$0099edc0$01cdc940$@JetBrains.com>

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

>> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Permissions pg_dump / import
  - From: Patrick B

References:
- Permissions pg_dump / import
  - From: Patrick B
- Re: Permissions pg_dump / import
  - From: Ilya Kazakevich

Prev by Date: Re: Re: Easiest way to compare the results of two queries row by row and column by column
Next by Date: Re: Critical failure of standby
Previous by thread: Re: Permissions pg_dump / import
Next by thread: Re: Permissions pg_dump / import
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux