Re: Transfer database tables to a schema

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Peter Darley" <pdarley(at)kinesis-cem(dot)com>, "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transfer database tables to a schema
Date: 2004-02-06 03:23:18
Message-ID: 002901c3ec60$97480180$a344053d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, I see what you mean. I was looking at pg_index, when the indexes are
also listed in pg_class. I will have to add this and the pg_depend stuff.

Best Wishes,
Chris Travers

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Travers" <chris(at)travelamericas(dot)com>
Cc: "Peter Darley" <pdarley(at)kinesis-cem(dot)com>; "Pgsql-General"
<pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, February 04, 2004 12:47 PM
Subject: Re: [GENERAL] Transfer database tables to a schema

> "Chris Travers" <chris(at)travelamericas(dot)com> writes:
> > Try this:
>
> Er ... what about the indexes belonging to the relation?
>
> regards, tom lane
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-06 06:11:24 Re: pgsql 7.4.1 copy - end-of-copy marker corrupt
Previous Message Joshua D. Drake 2004-02-06 02:27:12 Re: newbie question... how do I get table structure?