[Babase] Saving query output as a table

Catherine Markham amarkham at princeton.edu
Thu Jun 1 11:20:55 EDT 2006


Ok, forget both the period and the underscore.  Mine is working if I 
write something as simple as this at the start of the query...

create table doodlebug as [rest of query]

Doodlebug will be the name of the new table.

Catherine



Karl O. Pinc wrote:

> 
> On 06/01/2006 09:52:20 AM, Catherine Markham wrote:
> 
>> Weird.  I just tried Karl's first suggestion and it did work for me.   
>> Do you maybe need an underscore instead of a period?
> 
> 
> It's definately a period that separates the schema from
> the table.
> 
> I bet Leah's didn't work because she'd already tried that
> simple test before and she already has a lgerber.biograph
> table.  ??  (This is why I'd like to have the front-end dump
> directly from a query rather than having to go through
> a table.)
> 
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase


-- 
Catherine Markham
Department of Ecology and Evolutionary Biology
Princeton University

Phone: (609) 258-6898
Fax: (609) 258-2712


More information about the Babase mailing list