Received: from sandtstudent.pyr.ec.gc.ca (fwvan1.pyr.ec.gc.ca [199.212.20.2]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA50347 for ; Mon, 29 May 2000 12:21:30 -0400 (EDT) (envelope-from bernie.huang@ec.gc.ca) Received: from ec.gc.ca (IDENT:huangb@sandtstudent [131.235.150.249]) by sandtstudent.pyr.ec.gc.ca (8.9.3/8.9.3) with ESMTP id JAA30396 for ; Mon, 29 May 2000 09:21:21 -0700 Message-ID: <393298FF.AC011C73@ec.gc.ca> Date: Mon, 29 May 2000 09:21:20 -0700 From: Bernie Huang Organization: Environment Canada X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: PGSQL-SQL Subject: template or index of some kind Content-Type: multipart/mixed; boundary="------------A38AE6512151F1A3411458A4" X-Archive-Number: 200005/184 This is a multi-part message in MIME format. --------------A38AE6512151F1A3411458A4 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: 7bit Hi, I have a situation where there are hundreds of inventories that needs to be stored into postgres. And I am thinking of doing a template to ease the track of those inventories. Idea 1: each inventory may be an individual table, and the problem is how can I keep track of those tables? Idea 2: since all inventories have the same attribute, we can have a template for the entire inventory, and every time each item is retrieved, the info is filled into template. (This sounds like having a table for 'item'.) Please give me some feedback. Thank you. - Bernie --------------A38AE6512151F1A3411458A4 Content-Type: text/x-vcard; charset=iso-8859-15; name="bernie.huang.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bernie Huang Content-Disposition: attachment; filename="bernie.huang.vcf" begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:bernie.huang@ec.gc.ca title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard --------------A38AE6512151F1A3411458A4--