Thread: Change size of a field
Hi, Is it possible to change the size of a field ? Actually, I have a field called 'nom' in varchar(50) and I want this field in varchar(80). I can't do it with PgAdmin. Is it normal ? Tanks ------------------------------ http://www.ecolo.be
On Fri, 26 Jul 2002, ROUWEZ Stephane wrote: > Hi, > > Is it possible to change the size of a field ? > Actually, I have a field called 'nom' in varchar(50) and I want this field > in varchar(80). > I can't do it with PgAdmin. Is it normal ? Pretty normal! just 1) % pg_dump -t <tablename> <dbname> > <tablename>-DUMP.sql 2) % psql # drop sequence <tablename>_id_seq; 3) vi <tablename>-DUMP.sql change your varchar(50) to varchar(80) 4) psql #\i <tablename>-DUMP.sql There you go > > Tanks > > > ------------------------------ > http://www.ecolo.be > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
On Fri, 26 Jul 2002, Achilleus Mantzios wrote: I forgot! > 1) % pg_dump -t <tablename> <dbname> > <tablename>-DUMP.sql > 2) % psql > # drop sequence <tablename>_id_seq; ==>> # drop table <tablename>; > 3) vi <tablename>-DUMP.sql > change your varchar(50) to varchar(80) > 4) psql > #\i <tablename>-DUMP.sql -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
Hi, Thank you, it works but I loose my foreign keys and the privileges for groups and users. Is there a solution ? Stef -----Message d'origine----- De : Achilleus Mantzios [mailto:achill@matrix.gatewaynet.com] Envoye : vendredi 26 juillet 2002 14:50 A : ROUWEZ Stephane Cc : 'pgsql-sql@postgresql.org'; LESNE Philippe Objet : Re: [SQL] Change size of a field On Fri, 26 Jul 2002, ROUWEZ Stephane wrote: > Hi, > > Is it possible to change the size of a field ? > Actually, I have a field called 'nom' in varchar(50) and I want this field > in varchar(80). > I can't do it with PgAdmin. Is it normal ? Pretty normal! just 1) % pg_dump -t <tablename> <dbname> > <tablename>-DUMP.sql 2) % psql # drop sequence <tablename>_id_seq; 3) vi <tablename>-DUMP.sql change your varchar(50) to varchar(80) 4) psql #\i <tablename>-DUMP.sql There you go > > Tanks > > > ------------------------------ > http://www.ecolo.be > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr ------------------------------ http://www.ecolo.be