[GENERAL] how to store whole XML file in database

hi,, i have to insert whole xml file in database ,there is a text field for that.but it shows error parse error where there are attribute ..plz help me out.

[GENERAL] show all record between two date after group by and aggrigation...

i am fatching record's from data base between two date range for registration_date coloum and than group by an count it using count(registration_date) i have to show all dates even if date is not there in registration_date ,it should show date and 0 in count.,how can i do it plz healp...

[GENERAL] how to show serial number of record

hi i want to add a coloum called serial numer in my record set how could i do it..that column is not in table.

[GENERAL] Time Stamp auto Field

hi can we make a field auto incrementing field using Time Stamp data type

[GENERAL] problem in to_char() function

hi i want to convert 238.000 to 238.0 value 238.000 i got from database how to use to_char() function...??

[GENERAL] question for JAVA developer who r using postgres sql as backend

hi,   i am new for postgres sql.i have downloaded driver for postgres sql and trying to do connectivity through it.is it type 2 driver or type 4 driver..??-- Deepak PalSoftware Developer Wicenet ltd.Pune(M.H)

[GENERAL] what step need to configure postgres for java application

hi,    can anydody tell me what steps nee to configure postgres for java application.plz give me link frm where i got driver for it. -- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H )

[GENERAL] how to select second heigest salary...

hi   how to select second heigest salary from employee  table field are id,name ,salary...plz help-- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H)

[GENERAL] what datatype is for autonumbering.in postgress

hi i have to make ine field autonumber field what datatype should be used..?? plz reply meee.. On 4/3/06, William Leite Araújo <[EMAIL PROTECTED]> wrote: > You can make a function to do this. > > CREATE FUNCTION drop_operators(text) RETURNS BOOL AS > $$ > DECLARE > op record; >

[GENERAL] how to create script of database in postgres..sql(winxp)

hi   i am trying to make script file for my database by using pg_dump in windows as u say i open psql to postgres  then a prompt postgres# open then i write \i pg_dump it shows error.what should i do...plz hepl  

[GENERAL] how to use pg_dump in windows xp

hi   i have to create a database script file using pg_dump ,but i do not understant how to run it under windows enviornment plz hep me and replay mee soon...