On Mon, Nov 24, 2008 at 7:50 AM, Pascal Tufenkji <[EMAIL PROTECTED]> wrote:
> sql073751=> SELECT * into emp2 from emp;
>
> ERROR: emp: permission denied
> Creating a normal table works fine, but creating a table with subqueries is
> giving me "permission denied"
>
> Anyone got a clue?
You don't
Hello, I'm doing a workshop for my students and I'm teaching them how to
create tables in Postgres.
So I created a database for every student, but I'm facing the following
problem:
sql073751=> CREATE TABLE emp1 (id int);
CREATE TABLE
sql073751=> SELECT * into emp2 from emp;
ERROR: emp:
