Hi,
Within an couple of weeks we will start using PostgreSQL on Mandrake 8.1
in real business (we have been testing, for over a half year).
In future we will have some tables with 100.000+ records an the system
has te work very fast.
I know that speed of querries depend much on the amount of av
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 like to know how to timing a process? like in oracle sqlplus, we can set
timing on, then execute a statement, such way we can know how long the
process takes. In psql, is there such feature?
Anna Zhang
---(end of broadcast)---
TIP 4: Do
Probably not, but I don't the new version.
There are some ways you can do for this prupose.
Create a new table in that database without that columns. you can do
this very easily:
1. pg_dump -t table_name -s your_dbname > anyname.dump
the switch -s means without data, schem only. it is a
very
>Can I remove this column or will I need to drop the entire table and
restore from backup?
There's not a "remove column" option for alter table, but you may be able to
get around restoring by renaming the existing table, creating a replacement
the way you want it to look, & then copy from the ol
This is something I have been wanting for a long time. The ability to
update or drop a column from a table.
Right now you have to select the columns you want into a temp table and
drop the working table and rename the temp table to the working table.
|On 020123 12:15
|Jodi Kanter ([EMAIL PROTEC
I cannot seem to locate any documentation about removing a column that I
just added to a table. There is no data in that particular column but there is
in the rest of the table.
Can I remove this column or will I need to drop the entire table and
restore from backup?
Thanks
Jodi
___
Jodi Kanter <[EMAIL PROTECTED]> writes:
> select usf_fk from am_spots where ams_pk in (select min(ams_pk), max(ams_pk=
> ) from am_spots where am_fk>135);
> I received an error saying that my subselect has too many fields. Did I use=
> the wrong syntax or is it just a postgres rule that you can'
