Thread: 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)
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 >
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
-----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-----
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