Correct me if I'm wrong but this doesn't work if there are additional tables that rely on the table to be dropped for RI constraints.
culley
>>> "Command Prompt, Inc." <pgsql-general@commandprompt.com> 11/05/01 04:30PM >>>
> Do any of the developers out there have a feeling on when the DROP
> COLUMN command feature might be available?
I don't know if this will help you but until the DROP COLUMN feature is
added you could always use CREATE TABLE AS SELECT, drop the old table and
then rename the new.
> Or being able to query
> across multiple db's?
Let me know if you get an answer ;)
Sincerely,
Joshua Drake
Co-Author: Practical PostgreSQL
http://www.postgresql.info/>
> Russ
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>
http://archives.postgresql.org>
--
--
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/http://www.commandprompt.com/---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org