PostgreSQL Database Forum

hi, i have postgresql 8.1 and it was running very well but to store another database i copied the data folder of another database to C:\Program Files\PostgreSQL\8.1\ on my system then started service but as soon as i type the password to connect to the postgre,its showes a window named Server not listing, in which following messages is...

Hi, I need to create a table for audit. The data will come from of the triggers. Some values are variables and need to be passing as parameters. How to set TG_ARGV to hold that values? Thanks.

Hi there, i'm busy with quite a large project using PostgreSQL. Now the problem is that one of our data tables seems to have been corrupted. I cant open the table certain SQL queries like select does return results but the returned results are selective meaning that only certain fields are returned and not every thing that you asked for. Is...

Building OpenNMS 1.2.9 on OpenSUSE 10.3 using Postgres 8.2.7 When I run: $OPENNMS_HOME/bin/install -disU Output is: Exception in thread "main" org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at...

Hi, Is it possible for the COPY command to read data from a file, but skip specific columns? Thanks Adam

I want to convert the following query from SQL to HQL. SELECT student.first_name AS student_first_name, course.name AS course_name, course.id AS course_id, admission.admission_no AS admission_admission_no, attendance.status AS attendance_status, case WHEN attendance.status=1 THEN 'P' WHEN...

Hi, I want to extract date part (mm/dd/yy or any other date format) of Timestamp in postgreSQL. Can anyone help me out how I can proceed?. Regards, Ch.V.J. Kumar |Associate Consultant | iGATE Global Solutions Limited | Office: 5521701 xtn 3031 | 9886219429| Jitender.Chakka@igate.com

I would like to select strings from a table and return them as an array For example, select new_array(name) from my_tbl would return String { name1, name2, name3, etc } Is this possible with built-in SQL/psql functions? If not, how hard would it be to write a function that does this? (given that I have coding experience but none writing...

I am using postgres 7.3.4 and need to be able to determine which database a query is being run in (from a script). pg_database lists databases but doesn't tell me which one is currently active. Is there a query I can use along the lines of: UPDATE tblUpdates SET xxx=1234 WHERE pg_current = TRUE; or UPDATE tblUpdates SET xxx=1234 WHERE...

Hi All, How can I determine what version of postgresql is installed. Can't find answer in archives. thanks, Phil ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your

I Want To Combine The First Name Field And The Last Name Field Into One Single Field In The Same Table

Hi, I have a table with two column, date and data I would like to do a set of queries to generate statistics on the data, such as count(data) for month blocks and year blocks. What is the best way to accomplish this? dd/mm/yy date | data ---------------

hi I am having a startdate variable with timestamp datatype. I want to extract only the date from timestamp field........ select extract('hour' from timestamp '2001-02-16 20:38:40') this query extracts hour from the input in the same way is there any option for extracting only date. Please help as soon as possible.

I copied an example from the help: CREATE FUNCTION somefunc() RETURNS integer AS ' DECLARE quantity integer := 30; BEGIN RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here is 30 quantity := 50; -- -- Create a subblock

Currently I have a table defined as such: TAL=# \d internal_keywords Table "public.internal_keywords" Column | Type | Modifiers ---------+---------+----------- keyword | text | not null pid | integer | not null Indexes: internal_keywords_pkey primary key btree (keyword, pid) Foreign Key constraints: $1 FOREIGN KEY (pid)...

I added the reference to Npgsql.dll and run the application. it gives this run time error Could not load file or assembly 'Mono.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT:...

hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is problem with my access for now so i have to think of other choises. i wanted to know whether it is...

I am developing a client application for postgreSQL in Tcl/Tk (see http://gborg.postgresql.org/project/pfm ). It mainly uses PgTcl or pgintcl. I don't have any problems with those, but I am also trying to call psql from my application for SQL statements typed directly by the user. I have used the Tcl command set psqlChannel

Is there any way in Postgres to SELECT a list of table names from inside of a C program using ECPG? Something similar to SELECT current_user that will give you all of the tables in the database you are connected to. _________________________________________________________________ High-speed users—be more efficient online with the new MSN...

How do I decrypt the password of a user? What is the command used for decrypting the encrypted password to normal one? After entering into postgreSQL database and typing: postgres=# select * from pg_shadow; We will be getting the below listed fields.. i am a super user of the database.. password field shows...

Howdy. I looked around for an answer to this, but I was unable to find one that seemed to match my situation. (Incidentally, now I cannot get archives.postgresql.org to respond to my search query...) I'm trying to build 7.3.4 on Libranet2.8.1 (debian). I've built PostgreSQL many times in the past on stock RedHat distros and had no...

Hi, can somebody tell me How I can use the Oracle between function in Postgres? Like this: Select name from test Where date_f between '31.01.2000' And '31.01.2003' Thanxx

I've look for a solution to this, but have only been able to find solutions to delete duplicate entries in a table by deleting entries not returned by SELECT DISTINCT. What sql should I use to SELECT entries in a table that have two particular column values that match? For example, my_table has name, phone number, identification_number,...

hi all Is postgreSQL supports ROWNUM and ROWID ? -thanks- Chitranjan Singh

How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into the table. However, I must bundle them into a series of files because of the bug in PGSQL (the buffer overflows). Interestingly, the literature claims that the one feature of PostgreSQL is SPEED....