Sumbry][ wrote:
And of course in Postgres, there is no RENAME INDEX or
RENAME SEQUENCE command.
'alter table rename' works also for sequence
--
Best regards, Sergey Spiridonov
> So I renamed all sequences:
> ALTER TABLE alias_idnr_seq RENAME TO dbmail_alias_idnr_seq;
> ALTER TABLE user_idnr_seq RENAME TO dbmail_user_idnr_seq;
> ALTER TABLE mailbox_idnr_seq RENAME TO dbmail_mailbox_idnr_seq;
> ALTER TABLE physmessage_id_seq RENAME TO dbmail_physmessage_id_seq;
> ALTER TAB
Hi,
does anyone have a sql script to migrate a PostgreSQL database to table
name prefixes (it would be a good habit to only commit changes if there
is a script to migrate the database) ?
I tried the following:
ALTER TABLE acl RENAME TO dbmail_acl;
ALTER TABLE aliases RENAME TO dbmail_aliases;
ALT
