Thread
-
Re: How to simulate MEMO data type?Thanks!
Mitch Vincent <mitch@venux.net> — 2001-04-15T16:40:00Z
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!
Yann Ramin <atrus@atrustrivalie.eu.org> — 2001-04-15T17:06:42Z
-----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: How to simulate MEMO data type?Thanks!
Peter Eisentraut <peter_e@gmx.net> — 2001-04-15T17:15:58Z
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
-
How to simulate MEMO data type?Thanks!
Maurizio Ortolan <crix98__@tin.it> — 2001-04-15T17:18:38Z
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: [SQL] How to simulate MEMO data type?Thanks!
Christof Glaser <gcg@gl.aser.de> — 2001-04-15T17:24:00Z
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