Re: Problems Importing table to pgadmin

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 12/07/2016 04:02 PM, metaresolve wrote:
>> How many records and relational tables can pgadmin/postgres actually handle?

> https://www.postgresql.org/about/
> So you have plenty of head room.

Well, pgadmin and postgres are two different things.  pgadmin is mostly a
GUI, and AFAIK it's not really designed to perform well with query results
that are enormously larger than what you might want to scroll through
on-screen.

You might have better luck if you tell it to use COPY for bulk data
transfers.  I don't use it so I can't offer any detailed help, but
I believe that's possible.

            regards, tom lane