Re: Problems Importing table to pgadmin

From: metaresolve <solvemetare(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems Importing table to pgadmin
Date: 2016-12-08 01:19:30
Message-ID: 1481159970386-5933831.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Uh, yeah, it was a SELECT * from cc_20161207;

I know, it was dumb. I didn't realize it would break it or at least run for
a while. I tend to do things in small steps, run a query, check my results,
then tweak.

You're right, I wouldn't want to be viewing those million. so I guess I
could just be doing the top 10000 rows to get a sense, then be doing my
aggregate group bys/etc to get my final numbers? That's how I hacked Access
to be my data analysis program until I got to Alteryx. But I was also never
using files of 1M then.

--
View this message in context: http://postgresql.nabble.com/Problems-Importing-table-to-pgadmin-tp5933807p5933831.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-12-08 01:25:52 Re: Problems Importing table to pgadmin
Previous Message John R Pierce 2016-12-08 01:07:40 Re: Problems Importing table to pgadmin