Expand|Select|Wrap|Line Numbers
- ALTER TABLE public.postcodes
- ALTER COLUMN machi
- TYPE varchar(100);
Error while executing the query (State:42601, Native Code: 7)
I am using WinSQL, Windows XP SP2 Japanese Version, PostgreSQL 8.x.
I want to alter my machi field from varchar(30) to varchar(100) TYPE.
This is my CREATE TABLE script:
Expand|Select|Wrap|Line Numbers
- -- Table: public.postcodes
- -- DROP TABLE public.postcodes;
- CREATE TABLE public.postcodes (
- postcode varchar(8) NOT NULL,
- post varchar(6) NOT NULL,
- kencd varchar(3) NOT NULL,
- ken varchar(30) NOT NULL,
- shicd varchar(4) NOT NULL,
- shi varchar(30) NOT NULL,
- ku varchar(30),
- machi varchar(30) NOT NULL,
- status boolean,
- remarks text,
- /* Keys */
- CONSTRAINT postcodes_pkey
- PRIMARY KEY (postcode)
- ) WITHOUT OIDS;
- ALTER TABLE public.postcodes
- OWNER TO postgres;