Search Postgresql Archives

Re: Problems Importing table to pgadmin

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

 



On Wed, Dec 7, 2016 at 4:13 PM, metaresolve <solvemetare@xxxxxxxxx> 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@xxxxxxxxxxxxxx - 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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