From: | Jason Hihn <jhihn(at)paytimepayroll(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Wayne M(dot) Syvinski" <matthew(at)techcelsior(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: a: queries across databases b: plperl |
Date: | 2003-08-18 15:18:17 |
Message-ID: | NGBBLHANMLKMHPDGJGAPIEGOCMAA.jhihn@paytimepayroll.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
No, that's during creation. I mean after it's been created. Say I create my
tables, create a schema, then want to MOVE the tables to that schema.
There should also be a way to remove elements from a schema too, to outside
any schemas.
The three schema moves for existing tables that I am thinking about:
table1 -> schema1.table1
schema1.table1 -> table1
schema1.table1 -> schema2.table1
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Monday, August 18, 2003 9:48 AM
> To: Jason Hihn
> Cc: Wayne M. Syvinski; pgsql-novice(at)postgresql(dot)org
> Subject: Re: [NOVICE] a: queries across databases b: plperl
>
>
> Jason Hihn <jhihn(at)paytimepayroll(dot)com> writes:
> > Anyone know if there is a way to assign an element to a schema AFTER
> > creation?
>
> You mean as in "CREATE TABLE schema.table (..." ?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | jun queano | 2003-08-18 15:29:24 | Fw: Array Data Type |
Previous Message | jun queano | 2003-08-18 14:42:59 | Array Data Type |