[GENERAL] writing a file using procedure

Can we write/read a file in postgresql procedure ?

[GENERAL] relocation error-urgent

I have postgresql7.4.6 runing . I am not able to log into database using psql and also tried to create new database using createdb but getting the following error for both psql: relocation error: psql: undefined symbol: get_progname createdb: relocation error: createdb: undefined symbol: get_pro

[GENERAL] Extracting date from timestamp

Title: Extracting date from timestamp How to extract date(mm/dd/yyy) from a timestamp .

[GENERAL] pg_restore

Title: pg_restore Hi, I took a dump using the following command Pg_dump  -f  bk.dmp When I tried to restore  a table from the dump it just hangs there Pg_restore -f bk.dump -t table_name Also tried by giving username also Any light on this. Thnx Rao

Re: [GENERAL] not able to connect to Database

Hi, Psql -l gives names of databases in which it does not show "test". But same test I am still able to access through pgAdmin III utility. Regards Rao -Original Message- From: Ragnar Hafstað [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 2:46 AM To: Nageshwar Rao

[GENERAL] not able to connect to Database

Title: not able to connect to Database Hi, When I do psql test (database name) it says database "test" does not exists. But with pgAdminIII utility I get to see the database "test" and able to create tables ,insert the data etc. Why is this? Rgds Rao  

[GENERAL] Loading of native libraries in PLJAVA

Title: Loading of native libraries in PLJAVA     We are facing 2 problems in loading files from Pljava.      1. Loading Native C library from Pljava trigger.                 From Pljava trigger, we were trying to load native library, Using System.loadLibrary(""), wh

[GENERAL] Maximum size for varchar

Title: Maximum size for varchar What is the maximum number we can give for varchar (number) in postgresql 7.4.x Thanks Rao

Re: [GENERAL] Performance check using COPY commands

I do bulk insert of 5000 records. Rgds Rao -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 1:47 PM To: Nageshwar Rao Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Performance check using COPY commands Nageshwar Rao wrote: >

Re: [GENERAL] Performance check using COPY commands

I am trying to load some 5000 records now. It is still running for past 15 minutes, but when I check the table still I do not see records .And there is no status as how many records are inserted. Just left it like that .Also there are couple of issues. I have timestamp columns. In the excel

[GENERAL] insert data from an microsoft excel

Title: insert data from an microsoft excel Is there is way to load data from as Microsoft excel into database tables in postgresql7.4.x Thx Rao

[GENERAL] bytea

Title: bytea We have column job_data  with datatype bytea. This is one of the columns in table used by quartz scheduler(open source). We have to insert the data into it. The data is as follows. [-84,-19,0,5,115,114,0,21,111,114,103,46,113,117,97,114,116,122,46,74,111,98,68,97,116,97,77,97,11

[GENERAL] Shared disk

Hi, I would like to use shared disk for two Postgresql database. I mean that two Postgresql Database point to same $PGDATA directory. Is this possible in Postgresql Clarification is appreciated. Thx  

[GENERAL] Drop table

Title: Message Not able to drop a table,though nobody is accessing the table.I am able to insert the records and delete the records.When I give drop table it just hangs there .No error message. any specific reasons thx  

[GENERAL] granting privileges

How to grant privileges to all objects( tables,sequences etc) in specific schema, I mean I want to give users select,insert,delete and update to all objects in the schema in one sql statement.I know   Grant select,insert,update,delete on table_name to user_name.  But this is for individu

[GENERAL] increase the column size

I would like to change the column length from varchar(10) to varchar(30).How this can be done. Thx for help  

[GENERAL] tool for postgresql

Hi, Any tool available for Postgresql for admin activities like TOAD ( which is used for oracle database).Appreciate if somebody let me know. Thanks in advance.

[GENERAL] How to display structure of a table

I have created a table and would like to display the structure to find out datatype and length. Just like in Oracle describe table_name;

Re: [GENERAL] How to make a good documentation of a database ?

Hi, I have set of create table statements. I need to execute them at one go instead of running individual statement to create a table. Help ! Thx -Original Message- From: Timothy Perrigo [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 8:40 PM To: [EMAIL PROTECTED] Subject: Re

[GENERAL] clustering

.   Thanks Nageshwar Rao 91-80-25522059