[SQL] How to convert string to integer

Dear All, How do i convert string to int select SUM(pan_1) from customers1 where name='101' When i run the above query i m getting function sum(character varying) does not exist.. Please anyone can guide me.. Thanks

[SQL] How to Convert Integer to Serial

Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know. Thanks and Regards, Ven

Re: [SQL] How to Convert Integer to Serial

Dear All, I got the solution... Here is my query ALTER TABLE DemoTable ALTER gid TYPE INT2; Thanks again On Fri, Oct 29, 2010 at 10:18 AM, venkat ven.tammin...@gmail.com wrote: Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know

Re: [SQL] How to Convert Integer to Serial

ohhh,, sorry... It was wrong post..sorry again... On Fri, Oct 29, 2010 at 10:30 AM, Shoaib Mir shoaib...@gmail.com wrote: On Fri, Oct 29, 2010 at 3:48 PM, venkat ven.tammin...@gmail.com wrote: Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let

[SQL] How to update multiple rows

great response. Thanks and Regards, Venkat

Re: [SQL] [GENERAL] How to update multiple rows

as an expression SQL state: 21000 Please let me know where I am doing wrong.. guide me how to update those multiple records..I am waiting for your great response. Thanks and Regards, Venkat On Tue, Oct 26, 2010 at 1:32 PM, Alban Hertroys dal...@solfertje.student.utwente.nl wrote: On 26 Oct 2010, at 9:07

Re: [SQL] insert into help

HI, Please go through http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htm http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htmThanks and Regards, Venkat On Wed

[SQL] How to get geometry enabled Tables form Postgresql/postgis

Dear All, How can i retrieve only spatial enabled tables form the database(Postgresql/PostGIS).Please let me know. I am waiting for your great response. Thanks and Regards, Venkat

Re: [SQL] How to get geometry enabled Tables form Postgresql/postgis

Dear Lee, Perfect Its working fine Thanks alot.. Thanks and Regards, Venkat On Fri, Jul 30, 2010 at 1:43 AM, Lee Hachadoorian lee.hachadoor...@gmail.com wrote: All geometric columns in all spatially enabled tables appear in the table public.geometry_columns, defined as: CREATE

[SQL] How to Get Column Names from the Table

Dear All, How to get Column Names from Table in PostgreSQL. Thanks and Regards, Venkat

Re: [SQL] How to Get Column Names from the Table

Thanks alot Andreas...It is working fine... Thanks again. Venkat On Wed, Jul 7, 2010 at 2:44 PM, A. Kretschmer andreas.kretsch...@schollglas.com wrote: In response to venkat : Dear All, How to get Column Names from Table in PostgreSQL. select column_name from

Re: [GENERAL] [SQL] How to Get Column Names from the Table

Dear Sreelatha. It is working fine. Thanks alot. Thanks and Regards, Venkat On Wed, Jul 7, 2010 at 3:42 PM, Sreelatha G sreetla...@gmail.com wrote: Hi, To get column names only select column_name from information_schema.columns where table_name='captor_prime_aggregates'; Thanks

[SQL] How to Insert and retrieve multilingual (Hindi an Indian language) into PostgreSQL

Dear All, I want to insert and retrieve multilingual (Hindi) into database.is PostgreSQL supports that ?if it is ... please guide me how to enable multilingual in the table. I am waiting for your great response. Thanks and Regards, Venkat

[SQL] Postgresql PostGIS installation on Widows Server 2003

Dear All, I am using Windows Server 2003 for installing Postgresql 8.1. I got error called Filed to set permissions on installed files.And i have uninsulated 8.1 and i try to install 8.2. Here also I am getting same error.When try to install Postgresql 8.3, It is installed but i am not able to

[SQL] How to create Function which retruns username and password

Dear All, I want to create function which returns username and password from the database.I have users table in the database.in that i have username and password columns.I need return username and password using functions.it is urgent. I am waiting for your great response, Thanks, Regards,

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

[SQL] How to improve PgSql Performance using npgsql

) {} return pgSqlConnection; } Please let me where I am doing wrong. I am waiting for your great response. Advanced thanks. Reagrds, Venkat.

[SQL] How to Import Excel Into PostgreSQL database

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 to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

Dear All, I want to insert Images(bnp,png,etc) into Postgresql and how to retrieve the inserted Imaged using C#.net.I do not know where to start? Any one can help me. I am waiting for your great response. Advanced Thanks, Venkat.

Re: [SQL] Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

HI Milen, Thanks for your great response,I do not find anything like insert images.. I have seen the whole tutorial..Please can you give me some example to insert images into postgresql. I am waiting for your great response. Thanks, Venkat. On Thu, Dec 18, 2008 at 8:02 PM, Milen A. Radev mi