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 tables and functions. Copy and paste the coe into a new window, change the schema name, and execute. Then you can clear the 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