sheila bel wrote:
>
> Hi everyone,
>
> The data that needs to be copied is either text or password.
> This is what I think should be done please correct me if
> its wrong :
> COPY temptable(attributes) To permanent_table(attributes);
>
> If someone could give me an example I would really appreciate
> it.
>
> -Sheila
INSERT INTO permanent_table SELECT * from temptable;
Hope that helps,
Mike Mascari