[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