Thread: How to simulate MEMO data type?Thanks!

How to simulate MEMO data type?Thanks!

From
Maurizio Ortolan
Date:
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)


Re: How to simulate MEMO data type?Thanks!

From
"Mitch Vincent"
Date:
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!


> 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
>


Re: How to simulate MEMO data type?Thanks!

From
Peter Eisentraut
Date:
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


Re: How to simulate MEMO data type?Thanks!

From
Yann Ramin
Date:
-----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-----

Re: [SQL] How to simulate MEMO data type?Thanks!

From
Christof Glaser
Date:
On Sunday, 15. April 2001 19:18, Maurizio Ortolan wrote:
> Hello!
>
> I'm porting a database from MS Access
> to PostgreSQL.

Fine. Did you try the Access97-to-Postgres-7.1-Conversion Tool?
Click here: http://www.sevainc.com/Access

> How can I simulate in pgsql the 'MEMO'
> (up to 65000 chars) data type, which
> is often used in Access ?

No need to simulate: just use type TEXT.

> Where can I find an easy example?

Browse the documentation:
http://www.postgresql.org/users-lounge/

or read The Book:
http://www.postgresql.org/docs/awbook.html

> I don't' know if it's important, but
> I'm using Linux,Apache,Javascript &
> PHP.
> ^^^

http://www.php.net

Hope that helps,

Christof
--
          gl.aser . software engineering . internet service
       http://gl.aser.de/  . Planckstraße 7 . D-39104 Magdeburg
Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3