template or index of some kind - Mailing list pgsql-sql

From Bernie Huang
Subject template or index of some kind
Date
Msg-id 393298FF.AC011C73@ec.gc.ca
Whole thread Raw
List pgsql-sql
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

Attachment

pgsql-sql by date:

Previous
From: Grant Finnemore
Date:
Subject: Re: adding fields containing NULL values
Next
From: Bernie Huang
Date:
Subject: constraint