Skip site navigation (1) Skip section navigation (2)

Re: a: queries across databases b: plperl

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 (view raw or flat)
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
>


In response to

pgsql-novice by date

Next:From: jun queanoDate: 2003-08-18 15:29:24
Subject: Fw: Array Data Type
Previous:From: jun queanoDate: 2003-08-18 14:42:59
Subject: Array Data Type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group