Jodi,
Of course, we should have 'alter table drop column ' statement.
>Can I remove this column or will I need to drop the entire table and
restore from backup?
You can do as following:
select fields_you_want_to_keep into new_table from old_table.
Make sure that this statement execute su
Hi all,
I have one table containing data
as "source.txt" attached file. I want to create a script to clean the data
and get the result as "result.txt" attached file. inbtime and inbtime1 is datetime data
type.
Anyone has an idea?
Any help will be
appreciated.
thanks in a
Thank all of you very much. It works now.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "lonh SENG" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 9:14 AM
Subject: Re: [ADMIN] SQL Script
>
I use truncate table $table_name.
This will delete all data from that table and reset the sequense number.
- Original Message -
From: "Marc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 23, 2002 6:37 PM
Subject: [ADMIN] Reset sequence number
> Hello,
>
> How can
Hi all,
I use suse and
postgres7.0.
Do we have any rule to set
buffer and other thing of postmaster?
postmaster -N 128 -B 256 -D
/postgres/data
What do the above settings
mean?
TIA
Regards,
Lonh
Hi,
I don't think this is a good idea. But it is the thing that I have done.
You'd better need a programme to read all data from old db and insert
into new db.
Hope this help
Lonh
- Original Message -
From: "Prashanth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
