[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