Re: Problems Importing table to pgadmin - Mailing list pgsql-general

From David G. Johnston
Subject Re: Problems Importing table to pgadmin
Date
Msg-id CAKFQuwZwh7nd0gi-Vi2OB75fmXFg5R7KTwLCsQPKoByLbi03EQ@mail.gmail.com
Whole thread Raw
In response to Problems Importing table to pgadmin  (metaresolve <solvemetare@gmail.com>)
Responses Re: Problems Importing table to pgadmin
Re: Problems Importing table to pgadmin
List pgsql-general
On Wed, Dec 7, 2016 at 4:13 PM, metaresolve <solvemetare@gmail.com> wrote:
However, when I look at the table it's got the OID fields in there. From
what I read, the default is set to off, so I don't understand why they're
creating them.

<http://postgresql.nabble.com/file/n5933807/30652992334_36a60a0fed.jpg>

​The first 7 fields in the image are system fields that are always present but should never be visible.  I'd raise a complaint over on pgadmin-support@postgresql.org - or learn the psql utility.

Also,

On the second image you are using double-quotes to delimit a string literal.  This is wrong.  PostgreSQL always uses single quotes to indicate literal string value double quotes are reserved for object identifiers (table names, column names, etc).

David J.

pgsql-general by date:

Previous
From: metaresolve
Date:
Subject: Problems Importing table to pgadmin
Next
From: metaresolve
Date:
Subject: Re: Problems Importing table to pgadmin