Postgres Pro
Downloads
Home   >   mailing lists

Re: Facing error trying to pull out data from column - Mailing list psycopg

From Jim Nasby
Subject Re: Facing error trying to pull out data from column
Date
Msg-id b6797a6d-9786-8374-0c86-160ec72c03de@BlueTreble.com
Whole thread Raw
In response to Re: Facing error trying to pull out data from column  (Adrian Klaver <adrian.klaver@aklaver.com>)
List psycopg
Tree view 
On 6/4/16 9:30 PM, Adrian Klaver wrote:
>> And I want to print and cycle through all of the LTRS/ML (quantity
>> columns) for every product name that I have. How do I go about that?

Another suggestion: build your column list once, and run ONE query, not
hundreds or thousands. You'll get MUCH better performance.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461

psycopg by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Facing error trying to pull out data from column
Next
From: "Philipp H. v. Loewenfeld"
Date:
Subject: possible SQL injection problem in ZPsycopgDA