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:[EMAIL PROTECTED]] Envoye : vendredi 26 juillet 2002 14:50 A : ROUWEZ Stephane Cc : '[EMAIL PROTECTED]'; 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: [EMAIL PROTECTED] [EMAIL PROTECTED] ------------------------------ http://www.ecolo.be ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
