[Babase] Saving query output as a table

Catherine Markham amarkham at princeton.edu
Thu Jun 1 10:52:20 EDT 2006


Weird.  I just tried Karl's first suggestion and it did work for me.  Do 
you maybe need an underscore instead of a period?

Leah Gerber wrote:

> Karl O. Pinc wrote:
> 
>>
>> On 06/01/2006 09:13:55 AM, Catherine Markham wrote:
>>
>>> Hi Karl and Leah,
>>>
>>> Any ideas for what I'm doing wrong with the following?
>>
>>
>> There's also something on the wiki at:
>> http://papio.biology.duke.edu/babasewiki/GettingStartedWithBabase
>>
>> If that's not clear enough then change it.
>>
>> The alternate mechansim is to alter the schema search
>> path.  There's a box on the SQL query page ofthe phppgadmin interface
>> or the SET command can be used.  But I think adding the
>> schema to qualify the new tablename is better than having
>> to constantly fuss with that.
>>
>> 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
> 
> I just tried a very simple query and it did not work
> 
> CREATE TABLE lgerber.snames AS
> SELECT sname FROM biograph;
> 
> I swear this used to work. Any idea what could be different?
> 
> Leah
> 
> 
> 
> _______________________________________________
> 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