When I need to change table (e.g. adding new column or changing col attr)
I used the following:
1) dump the table: pg_dump -t my_table > my_table.out
2) edit my_table slightly (e.g. remain only COPY statement)
3) delete table my_table (also my_table's sequences if any)
4) create table as it shoul
Hello all
Does anybody know the way to:
1) Get count of elements in postgres array? E.g. for column of
a type TEXT[] for example?
2) Check the column (field) wasn't set during tuple creation? E.g.
CREATE TABLE foo (a INT4, b TEXT);
INSERT INTO foo (b) VALUES ('asdf');
Field
I don't understand the answer : you mean it is possible to backup (pg_dump) while
users are still connected to the DB ? And this should be available only for version 7
? Not versions 6.5.x ?
Nicolas Huillard
-Message d'origine-
De: Herbert Rabago Ambos [SMTP:[EMAIL PROTECTED]]
Date
Everything I have read indicates that there is no need to take down the
database server before doing a backup. This is true regardless of the
number of connected users and what they are working on at the time. In
fact pg_dump fails unless postmaster is running. The only reason you
would want to
I think in a lot of situations that process is necessary, but all I
wanted to do was change the not null flag from true to false.
I went ahead and test this out and it worked. All I did was:
update pg_attributes set attnotnull = 'f' where oid =
oidofnotnullcolumn;
vacuum analyze;
Everything s
