Change all tables, view and sequences owner in a Postgres DB from bash: Tables: for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" maksenov` ; do psql -c "alter table \"$tbl\" owner to maksenov" maksenov; done Sequences: for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" maksenov` ; do psql -c "alter sequence \"$tbl\" owner to maksenov" maksenov ; done Views: for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" maksenov` ; do psql -c "alter view \"$tbl\" owner to maksenov" maksenov; done
initial postgres beauty
после установки свежего экземпляра postgresql отображение в консоли psql не очень радует на больших строках, которые не вмещаются в экран 🙂
поправим пейджинг:
cd echo "\setenv PAGER 'less -XS'" > .psqlrc
поправим bash prompt string:
echo 'PS1=["\u@\h \w]\$ "' >> .bash_profile