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
ohhh,, sorry... It was wrong post..sorry again...
On Fri, Oct 29, 2010 at 10:30 AM, Shoaib Mir wrote:
> On Fri, Oct 29, 2010 at 3:48 PM, venkat wrote:
>
>> Dear All,
>>
>> I want to convert integer datatype to serial datatype.. is that
>> possible.Please let
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 wrote:
> Dear All,
>
> I want to convert integer datatype to serial datatype.. is that
> possible.Please let me know.
&g
Dear All,
I want to convert integer datatype to serial datatype.. is that
possible.Please let me know.
Thanks and Regards,
Ven
no,murabano)
I am getting below error..
"ERROR: more than one row returned by a subquery used 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,
;1' and murabano='119'
Please let me know.I am waiting for your great response.
Thanks and Regards,
Venkat
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.htm>Thanks
and Regards,
Venkat
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
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
Dear Sreelatha.
It is working fine. Thanks alot.
Thanks and Regards,
Venkat
On Wed, Jul 7, 2010 at 3:42 PM, Sreelatha G wrote:
> Hi,
>
> To get column names only
>
> select column_name from information_schema.columns where
> table_name='captor_prime_aggregates
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.
Dear All,
How to get Column Names from Table in PostgreSQL.
Thanks and Regards,
Venkat
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
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
t
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,
Ve
eption exp)
{}
return pgSqlConnection;
}
Please let me where I am doing wrong.
I am waiting for your great response.
Advanced thanks.
Reagrds,
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.
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
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.
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
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.
Dear All,
I am new to PqSQL. I have one problem.that is i want to make relation 4
tables.How to do in postgresql.Please any can help me.
I am waiting for your great response.
Advanced Thanks,
Regards
Venkat
22 matches
Mail list logo