[GENERAL] how to store whole XML file in database

[deepak pal]

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

[deepak pal]

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

[deepak pal]

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

[deepak pal]

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

[GENERAL] problem in to_char() function

[deepak pal]

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

[deepak pal]

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

[deepak pal]

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

[deepak pal]

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

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

[deepak pal]

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

[GENERAL] what datatype is for autonumbering.in postgress

[deepak pal]

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;
   BEGIN
 FOR op IN SELECT opname
  FROM pg_operator as o left join pg_namespace as n on (
 o.oprnamespace = n.oid)
  WHERE nspname = $1
 LOOP
   EXECUTE 'DROP OPERATOR '||quote_literal(op.opname)||';';
 END LOOP;
 RETURN TRUE;
   END;
   $$ LANGUAGE 'plpgsql' IMMUTABLE;

   And so: SELECT drop_operators('public');

 On 3/31/06, Martin Pohl [EMAIL PROTECTED] wrote:
 
 
  Hi,
 
  I have a database with operators and functions in plpgsql.
  To update the data to the latest version I would like to drop all
  operators.
  There might be some, that I don't know. I don't have access to the
  database,
  but have to write a script, that will update the data.
 
  Is there any way to drop all operators (given they are all in the schema
  public) in a script?
 
  Something like (pseudocode):
  Drop all operators in schema public
 
  Thanks in advance for answers
 
  --
  E-Mails und Internet immer und überall!
  11 PocketWeb, perfekt mit GMX: http://www.gmx.net/de/go/pocketweb
 
  ---(end of broadcast)---
  TIP 1: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly
 



 --
 William Leite Araújo



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[GENERAL] how to use pg_dump in windows xp

[deepak pal]

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