Re: Error when building new db using pg_restore

On 06/21/2017 05:06 PM, Jim Longwill wrote:
> On 06/21/2017 01:21 PM, David G. Johnston wrote:
>> On Wed, Jun 21, 2017 at 1:10 PM, Jim Longwill <JLongwill(at)psmfc(dot)org>
>> wrote:
>>
>>> rdev1=# \dd
>>> Object descriptions
>>> Schema | Name | Object | Description
>>> --------+------+--------+-------------
>>> (0 rows)
>> Nothing user created has comments by default. \dd only shows a very
>> limited subset of user created objects by default. That you didn't
>> explicit add comments to any of those types objects is unsurprising.
>> See the docs for exactly what "\dd" and "\ddS" will consider.
>>
>> David J.
> Ok.. I've tried again using psql \dd.. type commands to locate this
> COMMENT object,
> including as 'postgres' and in the source database of the tar file but
> it does not show up.
> Yes.. we have never put in any object comments, so it must have come in
> from the postgres
> installation. It'll be tough to delete this thing if I can't find it,
> but oh well!

Did you try \dL?:

test=> \dL

List of languages

Name | Owner | Trusted | Description

-----------+----------+---------+------------------------------------------

plpgsql | postgres | t | PL/pgSQL procedural language

plpythonu | postgres | f | PL/PythonU untrusted procedural
language

>
> I won't worry about this much more, but if the system identifies it as
> an error then
> I thought it was at least worth making the inquiry. Thanks!
> --Jim :^)
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com