[Babase] Saving query output as a table
Leah Gerber
lgerber at duke.edu
Thu Jun 1 10:51:06 EDT 2006
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
More information about the Babase
mailing list