Re: [SQL] How to improve PgSql Performance using npgsql

2008-12-24 Thread Hilco Wijbenga
2008/12/24 Venkat Rao Tammineni : > try > { > pgSqlConnection.Open(); > } > catch (Exception exp) > {} I don't think you've really given enough information for anyone to answer your question but at the very least you sho

[SQL] How to improve PgSql Performance using npgsql

2008-12-24 Thread Venkat Rao Tammineni
Dear All, I am using npgsql.dll to connect postgresql database. Everything is working fine.but sometimes database is getting slow and even sometimes I am not getting data .I have written one function which access the data . Below is my code .. public NpgsqlConnection PgSqlDataCon

Re: [SQL] How much the max image size can be inserted into Postgresql

2008-12-24 Thread Scott Marlowe
On Wed, Dec 24, 2008 at 7:00 AM, venkat wrote: > Dear All, > > I want to insert image which is more than 1 GB.is it possible to store that > same size or we can store more than that.Please let me know . Wow. The need for transactional semantics and storage of > 1Gig file size is an odd set of r

Re: [SQL] How much the max image size can be inserted into Postgresql

2008-12-24 Thread Craig Ringer
venkat wrote: > Dear All, > > I want to insert image which is more than 1 GB.is it possible to store > that same size or we can store more than that.Please let me know . Assuming that: - You're using PostgreSQL 8.3, and - You're using large objects to store your images; then the appropriate se

[SQL] How much the max image size can be inserted into Postgresql

2008-12-24 Thread venkat
Dear All, I want to insert image which is more than 1 GB.is it possible to store that same size or we can store more than that.Please let me know . I am waiting for your great response. Advanced Thanks, Regards Venkat.

Re: [SQL] How to Import Excel Into PostgreSQL database

2008-12-24 Thread Tk421
    Try this: http://sqlmanager.net/products/postgresql/manager/         It's an application that includes a lot of tools for importing and exporting databases. It's the best tool i've used for these kind of actions, and to manage postgreSQL databases Venkat Rao Tammineni escribió:

Re: [SQL] How to Import Excel Into PostgreSQL database

2008-12-24 Thread Venkat Rao Tammineni
Hi , Thanks a lot. Regards Venkat. -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of A. Kretschmer Sent: Wednesday, December 24, 2008 2:54 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] How to Import Excel Into PostgreSQL da

Re: [SQL] How to Import Excel Into PostgreSQL database

2008-12-24 Thread A. Kretschmer
In response to Venkat Rao Tammineni : > Dear All, > > > > I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is > there any way to import ? . Create a CSV-File and import that with COPY. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (