creating postgres tables by passing a string to function - Mailing list pgsql-sql

From Scott cox
Subject creating postgres tables by passing a string to function
Date
Msg-id BAY109-F333FA3BE29E1744F29825FCD8F0@phx.gbl
Whole thread Raw
Responses Re: creating postgres tables by passing a string to function  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
I am storing data separated by month.
How do I perform Inserts and Selects based on something like this.

select * from (select  'shipped' || '0509') AS aShippingTable

The table 'shipped' || '0509' exists.

I am scanning barcode labels which have the '0509' on them and I want to 
move the data
to appropiate monthly tables. '0510' would represent shipped on 2005 
october.

Eventually I want to create, insert, select all based on passing a string 
such as '0509'  to a function.

I am a newbie.
Thanks in advance
-Scott




pgsql-sql by date:

Previous
From: gurkan@resolution.com
Date:
Subject: regular expression
Next
From: Cenk KIZILDAG
Date:
Subject: Getting user created tables from SQL