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