pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: How to simulate MEMO data type?Thanks!
5+ messages / 5 participants
[nested] [flat]
* Re: How to simulate MEMO data type?Thanks!
@ 2001-04-15 16:40 Mitch Vincent <mitch@venux.net>
parent: Maurizio Ortolan <crix98__@tin.it>
3 siblings, 0 replies; 5+ messages in thread
From: Mitch Vincent @ 2001-04-15 16:40 UTC (permalink / raw)
To: pgsql-sql; Maurizio Ortolan <crix98__@tin.it>; +Cc: pgsql-general@postgresql.org
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to simulate MEMO data type?Thanks!
@ 2001-04-15 17:06 Yann Ramin <atrus@atrustrivalie.eu.org>
parent: Maurizio Ortolan <crix98__@tin.it>
3 siblings, 0 replies; 5+ messages in thread
From: Yann Ramin @ 2001-04-15 17:06 UTC (permalink / raw)
To: Maurizio Ortolan <crix98__@tin.it>; pgsql-sql; +Cc: pgsql-general@postgresql.org
-----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-----
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to simulate MEMO data type?Thanks!
@ 2001-04-15 17:15 Peter Eisentraut <peter_e@gmx.net>
parent: Maurizio Ortolan <crix98__@tin.it>
3 siblings, 0 replies; 5+ messages in thread
From: Peter Eisentraut @ 2001-04-15 17:15 UTC (permalink / raw)
To: Maurizio Ortolan <crix98@tin.it>; +Cc: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* How to simulate MEMO data type?Thanks!
@ 2001-04-15 17:18 Maurizio Ortolan <crix98__@tin.it>
0 siblings, 4 replies; 5+ messages in thread
From: Maurizio Ortolan @ 2001-04-15 17:18 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-general@postgresql.org
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)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] How to simulate MEMO data type?Thanks!
@ 2001-04-15 17:24 Christof Glaser <gcg@gl.aser.de>
parent: Maurizio Ortolan <crix98__@tin.it>
3 siblings, 0 replies; 5+ messages in thread
From: Christof Glaser @ 2001-04-15 17:24 UTC (permalink / raw)
To: Maurizio Ortolan <crix98__@tin.it>; pgsql-sql; +Cc: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-04-15 17:24 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-15 17:18 How to simulate MEMO data type?Thanks! Maurizio Ortolan <crix98__@tin.it>
2001-04-15 16:40 ` Mitch Vincent <mitch@venux.net>
2001-04-15 17:06 ` Yann Ramin <atrus@atrustrivalie.eu.org>
2001-04-15 17:15 ` Peter Eisentraut <peter_e@gmx.net>
2001-04-15 17:24 ` Christof Glaser <gcg@gl.aser.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox