On Tue, Dec 17, 2013 at 1:29 PM, Stefan Schwarzer <stefan.schwarzer@unep.org> wrote: Hi there, I have dozens of tables where I need to rename one column in each of these. Is there any generic way to do that? I am not really familiar with the scripting possibilities of Postgres. Thanks a lot for your help! StefanYou can do with script. I made one on fly for this, other's might have more polished version. -bash-4.1$ more rename.sh#!/bin/bash OLDCOLUMN=aaNEWCOLUMN=afor i in $(psql -t -c "select table_schema||'.'||table_name from information_schema.tables where table_schema='public';")do /opt/PostgreSQL/9.3/bin/psql -p 5432 -U postgres -c "alter table $i rename column $OLDCOLUMN to $NEWCOLUMN;"doneReplace the port,user,OLDCOLUMN, NEWCOLUMN and SCHEMA according to your requirement.
Hi there, I have dozens of tables where I need to rename one column in each of these. Is there any generic way to do that?
I am not really familiar with the scripting possibilities of Postgres. Thanks a lot for your help! Stefan
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных