Re: Safe operations?

On 08/12/2018 05:41 PM, Samuel Williams wrote:
> I wish the documentation would include performance details, i.e. this 
> operation is O(N) or O(1) relative to the number of rows.
> 
> I found renaming a table was okay.
> 
> How about renaming a column? Is it O(1) or proportional to the amount of 
> data?
> 
> Is there any documentation about this?

https://www.postgresql.org/docs/10/static/sql-altertable.html

"RENAME

     The RENAME forms change the name of a table (or an index, sequence, 
view, materialized view, or foreign table), the name of an individual 
column in a table, or the name of a constraint of the table. There is no 
effect on the stored data.
"

> 
> Thanks
> Samuel


-- 
Adrian Klaver
adrian.klaver@aklaver.com