September 9th, 2008
msquared (Administrator)
|
Posting Guidelines. Please read before you post in a forum!
Please follow this site's Posting Guidelines when posting questions or answers.
Some highlights from the Guidelines:
Make a meaningful title for... more »
sticky
|
|
Database gone a bit wild
Hi all just recently a large postgres database that has been happily chugging away with no problems has gone a bit wild. It is in the... more »
|
|
Converting PostgreSQL DB to MS-SQL DB
Hi,
I want to convert my complete database of PostgresQL to MS-SQL.
I am some what successful in converting tables but the major problem is Functions... more »
|
|
create table MyVariable
Can I write in a plpgsql function a code like this:
declare mytablename char(10);
..........................
if .... then
... more »
|
|
Global(shared) variable in postgresql
hi
i need to use a integer value in the optimizer's code and i want to send that value to this code from outside
Is there anything like... more »
|
|
PostgreSQL Database backup from a C# application
I am developing a C# application and could not find any details on backing up the database using C#. I would like to provide the users of the... more »
|
|
set Locale?
hi all
i'm currently running a postgresql 8.2 server.
how to change the postgresql locale permanently especially for the date time format and... more »
|
|
Installing PostgreSQL on WEPOS
Hello people
I was wondering if it is possible to install PostgreSQL on a WePOS Operating System. MS says anything installable on XP can be... more »
|
|
need some help in function
i have a function:
CREATE OR REPLACE FUNCTION fn_confirm_sms("varchar", "varchar", "varchar", "varchar", "varchar")
RETURNS "varchar"... more »
|
|
Running function as superuser
How I can run a function written in plpgsql as superuser when I'm logged into the database as normal user with a restrict access to tables? more »
|
|
Bad date error
HI
Can Anyone help me in correcting the error.I have a datbase in psql which has a date field.While trying to insert it using php form i am... more »
|
|
weekday from timestamp?
hi,
im strugling with my dataset..
got a small pgsql db with a timestamp column in format YYYY:MM:DD HH:MM:SS for each record
how could i possibly... more »
|
|
day from date
Is there a function in postgresql to find weekday from date?
E.g. Given 2008-09-08 , it returns Monday. more »
|
|
Data Base Design
Please Help me out in the Design of Postgres Database for the criteria
1. We have 20 Area Offices -- each Area Office to have another 20 branches... more »
|
|
Postgres to Oracle
1 Reply |
Posted by: Saii
| Last post by rski, 38 days ago
what is the equivalent of CREATE CAST and CREATE AGGREGATE in Oracle, if any? more »
|
|
How can i use shared memorry in postgresql using c functions
Please give some suggestions to handle shared memory concept in postgresql using c functions with simple example program. more »
|
|
Dreamweaver CS3 , PostgreSQL and PHP
Can you use PostgreSQL within Dreamweaver CS3? more »
|
|
Is index on column updated if the column is updated but data does not change?
I have a BEFORE UPDATE trigger on a table that calls the tsvector_update_trigger() built in function to update a tsvector field.
Since this trigger... more »
|
|
How to connect to a remote postgresql via http
Hi,
I have just installed a postgresql server on a windows server. Now, I want to connect to it from a winodws desktop through http (intranet).
What... more »
|
|
access or postgree
I am a business contractor , I wanted to learn how to make web pages so I leaned xhtml, css, and Javascript . But I fell in love with programing.
At... more »
|
|
large database
pl tell me which is the best out of the following
I have got an application of php and postgresql and same has to be implemented as central server... more »
|
|
(select Extract(dow...))
Hi all
Does anyone know how to subtract the day of the week (in numbers)
from the current date
i tried
....(current_date + (SELECT EXTRACT(DOW... more »
|
|
Can I know the disfference between postgres restart and reload?
Hi all,
I am in confusion that, What is the difference between postgres server restarting and postgres server reloading
Any Explanation will be... more »
|
|
Passing tablename as argument into function
Create or replace function Test(strTable in text) return bigint as
$$
declare
intSum bigint;
begin
intSum:=(Select sum(salary) from... more »
|
|
select not using index
Hello,
My name is Mihaly Fazekas.
Sorry, my english is not good.
I have a query:
telefon=# EXPLAIN SELECT * FROM ext.ext_unit_hier WHERE... more »
|
|
connection statement
Hi
i am trying to connect postgres database using php.my database name is DB username=GPME and password=secret.I tried the pg_connect() using... more »
|
|
