[Babase] Saving query output as a table

Karl O. Pinc kop at meme.com
Thu Jun 1 10:36:11 EDT 2006


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?  I'm trying to  
> save the output of a query as a table and can't tell if my commands  
> are off or if it is simply a matter of permissions (I'm thinking the  
> latter based on the specific message that I get with the error).

> SQL error:
> 
> ERROR:  permission denied for schema babase
> 
> In statement:
> 
> create table table_name as
...

You need to qualify the table name so that it puts the new
table into your schema.

create table amarkman.table_name as ...

Otherwise, you are trying to put a new table
into the babase schema and you don't have permissions.
(See example 2.1 and the immediately preceeding text
at: http://papio.biology.duke.edu/babase_system_html/ch02s03.html)

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list