Received: from atp.atpn.com (pm1-46.corp.redshift.com [216.228.4.46]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3FH9Vu84684 for ; Sun, 15 Apr 2001 13:09:32 -0400 (EDT) (envelope-from atrus@atrustrivalie.eu.org) Received: (qmail 91030 invoked from network); 15 Apr 2001 17:06:45 -0000 Received: from localhost (HELO atp.atpn.com) (127.0.0.1) by localhost with SMTP; 15 Apr 2001 17:06:45 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Yann Ramin Organization: Atrus Trivalie Productions To: Maurizio Ortolan , pgsql-sql@postgresql.org Subject: Re: How to simulate MEMO data type?Thanks! Date: Sun, 15 Apr 2001 10:06:42 -0700 X-Mailer: KMail [version 1.2] Cc: pgsql-general@postgresql.org References: <5.0.2.1.2.20010415101736.01e4c608@box.tin.it> In-Reply-To: <5.0.2.1.2.20010415101736.01e4c608@box.tin.it> MIME-Version: 1.0 Message-Id: <01041510064200.90944@atp.atpn.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/614 X-Sequence-Number: 7762 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 If you're using PGSQL 7.1, your looking for a 'text' type field. Pre-7.1 the text field was limited to 8k, now its much larger. On Sunday 15 April 2001 10:18 am, Maurizio Ortolan wrote: > Hello! > > I'm porting a database from MS Access > to PostgreSQL. > > How can I simulate in pgsql the 'MEMO' > (up to 65000 chars) data type, which > is often used in Access ? > > Where can I find an easy example? > > I don't' know if it's important, but > I'm using Linux,Apache,Javascript & > PHP. > ^^^ > > Many thanks to all of you! > CIAO! > MAURIZIO > > > ******************************************* > ** Happy surfing on THE NET !! ** > ** Ciao by ** > ** C R I X 98 ** > ******************************************* > AntiSpam: rimuovere il trattino basso > dall'indirizzo per scrivermi... > (delete the underscore from the e-mail address to reply) > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html - -- - -------------------------------------------------------------------- Yann Ramin atrus@atrustrivalie.org Atrus Trivalie Productions www.redshift.com/~yramin AIM oddatrus Marina, CA http://profiles.yahoo.com/theatrus IRM/IRT Developer DVfootage.com developer SNTS Developer KLevel Developer When smashing monuments, save the pedstals -- they always come in handy. -- Stanislaw J. Lem, "Unkempt Thoughts" Nothing succeeds like excess. - Winston Churchill Deep in the human unconscious is a pervasive need for a logical universe that makes sense. But the real universe is always one step beyond logic. - Muad'Dib (Dune, Frank Herbert) - -------------------------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (FreeBSD) Comment: For info see http://www.gnupg.org iD8DBQE62dUlx6171htvP6YRAv7QAJ9cU9BEHqVinNJgd2nqor9DRf9ZsACeOqva RzFJ7wYylwzX/5rPNHeR/nI= =hpHE -----END PGP SIGNATURE-----