Re: [SQL] How to Import Excel Into PostgreSQL database
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 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] How to Import Excel Into PostgreSQL database
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 database 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 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] How to Import Excel Into PostgreSQL database
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ó: Dear All, I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is there any way to import ? . Please anyone can guide me. I am waiting for your great response. Thanks Venkat.
[SQL] How much the max image size can be inserted into Postgresql
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 much the max image size can be inserted into Postgresql
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 section of the MANUAL is: http://www.postgresql.org/docs/current/static/largeobjects.html If those assumptions are invalid or insufficient, perhaps you could provide a more complete description of how you're doing things? -- Craig Ringer -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] How much the max image size can be inserted into Postgresql
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 requirements. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] How to improve PgSql Performance using npgsql
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 PgSqlDataConnection()
{
if (pgSqlConnection != null)
{
if (pgSqlConnection.State == ConnectionState.Open)
{
pgSqlConnection.Close();
//pgSqlConnection.Dispose();
}
}
pgConnectionString =
ConfigurationSettings.AppSettings["ConnectionString"].ToString();
pgSqlConnection = new NpgsqlConnection(pgConnectionString);
try
{
pgSqlConnection.Open();
}
catch (Exception exp)
{}
return pgSqlConnection;
}
Please let me where I am doing wrong.
I am waiting for your great response.
Advanced thanks.
Reagrds,
Venkat.
Re: [SQL] How to improve PgSql Performance using npgsql
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 shouldn't just ignore
your exceptions. Maybe something fails but you'll never know.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
