Re: How to simulate MEMO data type?Thanks!
Use the unlimited length PostgreSQL type "text" (In 7.1 it's unlimited,
before there were limits).
-Mitch
----- Original Message -----
From: "Maurizio Ortolan" <crix98__@tin.it>
To: <pgsql-sql@postgresql.org>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, April 15, 2001 1:18 PM
Subject: How to simulate MEMO data type?Thanks!
Show quoted text
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?
Import Notes
Reference msg id not found: 5.0.2.1.2.20010415101736.01e4c608@box.tin.it
-----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?
- --
- --------------------------------------------------------------------
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-----
Import Notes
Reply to msg id not found: 5.0.2.1.2.20010415101736.01e4c608@box.tin.itReference msg id not found: 5.0.2.1.2.20010415101736.01e4c608@box.tin.it | Resolved by subject fallback
Maurizio Ortolan writes:
How can I simulate in pgsql the 'MEMO'
(up to 65000 chars) data type, which
is often used in Access ?
Use varchar or text and PostgreSQL 7.1. They can be up to about 1 GB in
size.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
Import Notes
Reply to msg id not found: 5.0.2.1.2.20010415101736.01e4c608@box.tin.it | Resolved by subject fallback