[EMAIL PROTECTED] writes:
>hello all!
>
>how to drop columns in postgresql?
There is no direct way to do it.
You should do the following steps:
^ get the table schema
(you may use pg_dump for this)
^ create a temporary table with the same schema
(just modify the table name)
^ copy the content of the original table to temporary table except the
deprecated column
^ drop the original table
^ rename the temporary table
^ (optional) run pg_dump again to check
if everything is in the correct place
sherwin
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
