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

From metaresolve
Subject Re: Problems Importing table to pgadmin
Date
Msg-id 1481159970386-5933831.post@n3.nabble.com
Whole thread Raw
In response to Re: Problems Importing table to pgadmin  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Problems Importing table to pgadmin
List 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.


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Problems Importing table to pgadmin
Next
From: Adrian Klaver
Date:
Subject: Re: Problems Importing table to pgadmin