Re: BUG #2901: missing alter table online help in psql - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2901: missing alter table online help in psql
Date
Msg-id 21380.1168966141@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2901: missing alter table online help in psql  ("Jens-Wolfhard Schicke" <j.schicke@asco.de>)
List pgsql-bugs
"Jens-Wolfhard Schicke" <j.schicke@asco.de> writes:
> \h alter table
> is missing the syntax for the command
> alter table the_table alter column the_column type varchar(175);

Maybe you're using an old psql?  My 8.2 psql shows

regression=> \h alter table
Command:     ALTER TABLE
Description: change the definition of a table
Syntax:
ALTER TABLE [ ONLY ] name [ * ]
    action [, ... ]
...
where action is one of:
...
    ALTER [ COLUMN ] column TYPE type [ USING expression ]
...


            regards, tom lane

pgsql-bugs by date:

Previous
From: "Jens-Wolfhard Schicke"
Date:
Subject: BUG #2901: missing alter table online help in psql
Next
From: Tom Lane
Date:
Subject: Re: BUG #2848: information_schema.key_column_usage does not work