Re: How to "COPY schema1.table TO schema2.table" ?

I really don't use either of those.  I use PgAdmin which with a few clicks displays the sql code used to create the
tablesand functions.  Copy and paste the coe into a new window, change the schema name, and execute.  Then you can
clearthe window and do a Insert into B (select * from A);  

I am sure the same can be done with psql but I don't know how.  Sorry.

On Thu, Jan 20, 2005 at 01:29:28PM +0100, Andreas Neumann wrote:
> Normally I use psql. Sometimes for a fast Browse phpPgAdmin.
>
> On Wed, 19 Jan 2005, Mike G. wrote:
> > What are you using to connect to the database? Pgadmin? psql?
> >
> > On Wed, Jan 19, 2005 at 03:34:58PM +0100, Andreas Neumann wrote:
> > > Hi,
> > >
> > > how can I copy a table (including sequences etc.) to a different schema?
> > >
> > > Kind regards,
> > >
> > >   Andreas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster