Re: Safe operations? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Safe operations?
Date
Msg-id dddf5f6d-9270-a64f-35c5-830c05aafd77@aklaver.com
Whole thread Raw
In response to Safe operations?  (Samuel Williams <space.ship.traveller@gmail.com>)
Responses Re: Safe operations?
List pgsql-general
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


pgsql-general by date:

Previous
From: Samuel Williams
Date:
Subject: Safe operations?
Next
From: Tim Cross
Date:
Subject: Re: Safe operations?