| |
thread by: pankajprakash |
last post Dec 11 '07 by: GustavoCB
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...
|
thread by: Jorge Destri Jr |
last post Jun 24 '07 by: michaelb
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.
|
thread by: JohanK |
last post Feb 2 '07 by: JohanK
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...
|
thread by: ggarrette |
last post Jul 24 '08 by: rski
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...
|
thread by: Adam Witney |
last post Nov 23 '05 by: Adam Witney
Hi,
Is it possible for the COPY command to read data from a file, but skip
specific columns?
Thanks
Adam
|
thread by: shiniskumar |
last post Jun 5 '07 by: michaelb
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...
|
thread by: Jitender Kumar C |
last post Nov 12 '05 by: nolan
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
|
| |
thread by: Andy Kriger |
last post Nov 22 '05 by: elein
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...
|
thread by: Ron St-Pierre |
last post Nov 22 '05 by: Ron St-Pierre
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...
|
thread by: Phil Campaigne |
last post Nov 22 '05 by: Reece Hart
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
|
thread by: sagarbaswa |
last post Jan 3 '08 by: rski
I Want To Combine The First Name Field And The Last Name Field Into One Single Field In The Same Table
|
thread by: Mat |
last post Nov 11 '05 by: Ron Johnson
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
---------------
|
thread by: priyan |
last post Aug 11 '07 by: priyan
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.
|
thread by: Thomas LeBlanc |
last post Nov 12 '05 by: Chet Luther
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
|
thread by: Jean-Christian Imbeault |
last post Nov 11 '05 by: Richard Huxton
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)...
|
| |
thread by: pathmakumara |
last post Mar 4 '13 by: skosanabv
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:...
|
thread by: nehashri |
last post Apr 11 '24 by: coldbluts
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...
|
thread by: Willem Herremans |
last post Nov 23 '05 by: Richard Huxton
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
|
thread by: Eric Freeman |
last post Nov 22 '05 by: Chris Travers
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...
|
thread by: bhavanik |
last post Apr 26 '18 by: salimdev
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...
|
thread by: Michael Teter |
last post Nov 12 '05 by: Alvaro Herrera
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...
|
thread by: Amin Schoeib |
last post Nov 11 '05 by: Pavel Stehule
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
|
thread by: Kall, Bruce A. |
last post Nov 23 '05 by: Edward Macnaghten
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,...
|
| |
thread by: chitranjan |
last post Mar 27 '12 by: jablonov
hi all
Is postgreSQL supports ROWNUM and ROWID ?
-thanks-
Chitranjan Singh
|
thread by: John Kolvereid |
last post Jul 19 '05 by: Warren Killian
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....
|