Error while renaming the column in postgres

Question

I have created new table by:

CREATE TABLE DIFF_ODATE_PERIOD AS
select test_3.odate - test_3.max_period from test_3;

And it gave me column name: ?column? And when I am trying to change the name it gives me error:

  ALTER TABLE DIFF_ODATE_PERIOD
  RENAME COLUMN ?column? TO test;

ERROR: syntax error at or near "?" LINE 71: RENAME COLUMN ?column? TO test;

Can I define the name while creating or after?

GMB · Accepted Answer · 2020-11-25 10:54:48Z

2

You would need to alias that column directly in the create table ... as select statement:

create table diff_odate_period as
select odate - max_period as test from test_3;

answered Nov 25, 2020 at 10:54

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1