[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