[ http://bytes.com/adLoader.php?parent=database

Forums

Forums for tech professionals. Ask your questions!

Programming Languages

C / C++ Java .NET Visual Basic Python

Web Development

PHP Ruby / Rails Perl ASP Coldfusion Javascript / Ajax Flash / Actionscript XML HTML / CSS

Database

MySQL Oracle SQL Server PostgreSQL Access DB2

System Administration

Apache IIS Networking Linux / Unix / BSD Windows

Software Development Mobile Development Misc Questions

Howtos

Browse all Howtos and articles here

Jobs

Browse All Jobs Post Job Listing

Bytes > Forums - Questions and Answers > PostgreSQL Forum

PostgreSQL Forum

PostgreSQL ORDBMS database - Ask questions about PostgreSQL development, administration replication, clustering, connection pooling, tables, indexes, databases, performance, SQL, queries and more.

Subscribe View Unanswered Questions Post a Question

Views: 3,217

Announcement: New Bytes Desktop Application in development

September 9th, 2008 msquared (Administrator)

Posting Guidelines. Please read before you post in a forum!

2 Replies | Posted by: michaelb | Last post by michaelb, 537 days ago

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

Post Reply? | Posted by: jac43 | Last post by jac43, 3 days ago

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

Post Reply? | Posted by: deepusurana | Last post by deepusurana, 3 days ago

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

1 Reply | Posted by: danciu | Last post by rski, 4 days ago

Can I write in a plpgsql function a code like this: declare mytablename char(10); .......................... if .... then ... more »

Global(shared) variable in postgresql

Post Reply? | Posted by: mangesh2209 | Last post by mangesh2209, 6 days ago

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

3 Replies | Posted by: harvindersingh | Last post by r035198x, 12 days ago

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?

1 Reply | Posted by: ferryferdian | Last post by r035198x, 13 days ago

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

1 Reply | Posted by: harvindersingh | Last post by r035198x, 13 days ago

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

1 Reply | Posted by: jesmi | Last post by rski, 24 days ago

i have a function: CREATE OR REPLACE FUNCTION fn_confirm_sms("varchar", "varchar", "varchar", "varchar", "varchar") RETURNS "varchar"... more »

Running function as superuser

2 Replies | Posted by: ildiff | Last post by ildiff, 25 days ago

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

3 Replies | Posted by: sreenisha | Last post by rski, 34 days ago

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?

1 Reply | Posted by: rdkrdk | Last post by rski, 35 days ago

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

1 Reply | Posted by: powarsony84 | Last post by rski, 35 days ago

Is there a function in postgresql to find weekday from date? E.g. Given 2008-09-08 , it returns Monday. more »

Data Base Design

1 Reply | Posted by: kompallikedar | Last post by ferryferdian, 35 days ago

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, 37 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

1 Reply | Posted by: prathapshetty13 | Last post by rski, 37 days ago

Please give some suggestions to handle shared memory concept in postgresql using c functions with simple example program. more »

Dreamweaver CS3 , PostgreSQL and PHP

Post Reply? | Posted by: itreport | Last post by itreport, 38 days ago

Can you use PostgreSQL within Dreamweaver CS3? more »

Is index on column updated if the column is updated but data does not change?

Post Reply? | Posted by: rverghese | Last post by rverghese, 38 days ago

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

3 Replies | Posted by: irhernan | Last post by rski, 40 days ago

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

2 Replies | Posted by: 480Leonidas | Last post by rski, 41 days ago

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

1 Reply | Posted by: kompallikedar | Last post by rski, 43 days ago

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

1 Reply | Posted by: Bot44 | Last post by rski, 43 days ago

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?

2 Replies | Posted by: aurekha | Last post by aurekha, 44 days ago

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

1 Reply | Posted by: gouse | Last post by rski, 48 days ago

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

2 Replies | Posted by: vaxx | Last post by vaxx, 52 days ago

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

6 Replies | Posted by: sreenisha | Last post by sreenisha, 52 days ago

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 »

1 2 3 4 5 6 . . . 26 Next »

Latest Articles: Read & Comment

Why Values in Unbound Form Controls Don't Persist 10 Tips to Avoid Information Overload at Work How to Freelance to Your First Million, It's been done! 10 Technologies to Help Cut Costs in the Slow Economy Dragging and Dropping Files Into your C#.NET Program