[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, Ve

[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 t

[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] 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.

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 wrote: > Hi, > > To get column names only > > select column_name from information_schema.columns where > table_name='captor_prime_aggregates&#

[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

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.htm>Thanks and Regards, Venkat

[SQL] How to update multiple rows

;1' and murabano='119' Please let me know.I am waiting for your great response. Thanks and Regards, Venkat

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

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,

[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 wrote: > Dear All, > > I want to convert integer datatype to serial datatype.. is that > possible.Please let me know. &g

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 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

[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] Reg:-How to make relationship more one table in PgSQL

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

[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

[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.

[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.

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

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