[SQL] RE: DBD and DBI::Pg

2001-04-15 Thread Sterin, Ilya
Install DBI and DBD::Pg modules for perl. You can download them from www.cpan.org and then follow the installations instructions. It is also preferable by us and everyone else that you not cross post your question to 50 different groups. Please keep on topic. In DBI case [EMAIL PROTECTED] coul

Re: [SQL] Same question about PostgreSql

2001-04-15 Thread Josh Berkus
Sergey, > How stable is PostgreSql ? More than Interbase :-) More than MS SQL Server. Maybe less than Oracle or MySQL; it's open to debate. Futher, because everything in Postgresql is "open" -- source code, data files, system tables -- in the event of hardware or platform failure you can alwa

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

2001-04-15 Thread Yann Ramin
-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 Post

[SQL] Re: [GENERAL] How to store gif or jpeg? Thanks!

2001-04-15 Thread Nelson Ferreira Jr
Hello! When you store data with PostgreSQL as BLOBs it doesn't matter if it's an image, sound or whatever - everything works in the same way. So you should use the image type that better represents your images. You can find some information about how to use it below: psql: (see the co

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

2001-04-15 Thread Christof Glaser
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) d

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

2001-04-15 Thread Mitch Vincent
Use the unlimited length PostgreSQL type "text" (In 7.1 it's unlimited, before there were limits). -Mitch - Original Message - From: "Maurizio Ortolan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 15, 2001 1:18 PM Subject: How to simulate MEMO d

[SQL] RTREE on points

2001-04-15 Thread Julian Scarfe
Am I missing the point (no pun intended ;-) of RTREE indices? I was expecting a "point_ops" opclass or similar... [7.1 on RedHat 6.2] SELECT am.amname AS acc_name, opc.opcname AS ops_name, COUNT(*) FROM pg_am am, pg_amop amop, pg_opclass opc WHERE amop.amopid

[SQL] How to store gif or jpeg? Thanks!

2001-04-15 Thread Maurizio Ortolan
Hello! In your opinion, which is the best way to store images (gif o jpg) with PostgreSQL? Where can I find an easy example? Many thanks to all of you! CIAO! MAURIZIO *** ** Happy surfing on THE NET !! ** ** Ciao by

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

2001-04-15 Thread Maurizio Ortolan
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