PostgreSQL Database Forum

Please follow this site's Posting Guidelines when posting questions or answers. Some highlights from the Guidelines: Make a meaningful title for your thread. "Please Help!" is not one of those. Include your code snippets into the CODE tags; use the menu icons on the GUI. Provide enough information, so others can help you. This may include...

Hi, is there a way , other than using EMS PostGreSql Extract to export a PostGreSql datatbase ( table structures,data , functions , triggers etc... ) to sql. i tried EMS PostGreSql Extract , but the sql is specific to PostGreSql ( needing some editing for running on MSSql ) also the sequence of table creation was conflicting with

Dear all, I am new to SQL programming. I'd like to know what are the usual practices in documenting the table schema. How to document relationship among tables? (by diagram or text description?) If I need to draw the schema in diagram, which software should I use? (Dia? any better tools?)

Hi there, I need to do something like this: -- Function: public."ModifyOrder"(int4, text, int4) CREATE FUNCTION public."ModifyOrder"(int4, text, int4) RETURNS void AS 'UPDATE orders SET $2 = $3 WHERE "OrderId" = $1;' LANGUAGE 'sql' IMMUTABLE; COMMENT ON FUNCTION public."ModifyOrder"(int4, text, int4) IS 'ModifyOrder(OrderId,...

How do you stop postgres

Can I install Posgresql on slackware linux? This package doesn't include with slackware. I have visited on postgresql website, but it only for Red Hat linux. Where can I get postgresql for Slack?

From what I've read, when accessing a PostgreSQL database the dataset returned is considered to be UniDirectional in that one cannot execute an effective 'MovePrior' when acessing the database using ODBC. Is this correct? -- Hal Davison Davison Consulting

Good morning, I have table1 and table2. table1 has 3 columns for exemple (a1,b,c) and table2 has 2 (a2,d) (a is primary key for both tables) I create a new column e for table1 wich is b and I want to put all the values of d in e when a1=a2. What is the command please ??? I really need that command.. HELP

Hi... I am currently working on a Java-based product that is backed by PostgreSQL (among other databases). I have noticed that PostgreSQL appears to truncate column alias names after 31 characters. I have replicated this through JDBC (in Java), PEAR (in PHP), and on the command-line interface (psql). For example (this is from the...

If a row of data has been locked FOR UPDATE, how can one determine WHO has it locked? -- Hal Davison Davison Consulting

I would like to map from GPS coordinates to US Zipcode for US Continental based needs. (Yes, I am excluding perhaps Hawaii and Alaska for now, and I am also assuming that a simple 2D geometry, assuming the GPS coordinates are Euclidean and not spherically based will be good enough to find the closest zip code.) So assuming something...

I have a table sort of like: create table firehydrants ( center point, hydrant integer primary key, ); How do I create firehyrants2 from firehydrants where the points are broken out into their x and y values?

Hi! I dumped a DB using pg_dump from version 7.2.3 and tried to read it into DB with psql|pg_restore of version 7.3.3. I got an error 'pg_atoi: zero-length string' during the creation of relations. Don't know what to do with it. TIA -- Marcin "Dentharg" Gil

I have very large databases that are in postgresql (500Gbs) and individual tables that take up as much space as 4 GBs. I know that in mysql one can compress individual tables with isam-compression. I understand that postgresql compresses text automatically, is there anyway to compress my large database further? Thanks.

I have very large databases that are in postgresql (500Gbs) and individual tables that take up as much space as 4 GBs. I know that in mysql one can compress individual tables with isam-compression. I understand that postgresql compresses text automatically, is there anyway to compress my large database further? Thanks.

Hi, I am in the process of converting mysql tables to postgres by means of mysqldump and then mysql2pgsql tool. However, the tables are very large (>2Gbs) and I would like to recreate some of these database tables in mysql on different machines and then dump and convert them to postgres on that machine, after which I would copy the newly...

I am writing an application that inserts into a PostgreSQL database, but I would like to know whenever a rollback occurs, whether there is an error relating to referential integrity, etc., so that my client software will know. I am using RealBasic as the front end development. Any suggestions how to get Postgre to return these messages? ...

Gentlemen, I am hoping to be able to use GForge on my windows PC. To that end I have installed: 1. cygwin 2. reinstalled cygwin and selected cygipc, postgreSQL and a few other things 3. PHP 4 Apache 5. downloaded and installed the GForge3 directory tree

Hi All - is there a way to enable multibyte encoding after I have already installed Postgres on Linux ? I need to be able to accept French characters. Thanks, Sylvie.

How do you drop a column in php?

Hi All, I am posting this through google, as my news server does not subscribe to this group. Anyone have a recommendation of a good news server that carries this group? Many thanks, --Tony aewell@gbis.com

Hi All, I am in the unique situation of designing a new Red Hat 9 server to run a Postgres database in a small company. The database that is being converted is currently 30 MB. There will be 20 users maximum. As I am a newbie to Postgres, I do not know where the data is stored (/usr?). Since I am starting from scratch, I thought I'd...

Table "grps" Column | Type | Modifiers -------------+-----------------------------+-------------------------------- --------------------- grpsid | integer | not null default nextval('"grps_grpsid_seq"'::text) grpsname | text | not null...

Hi there, Can I get opinions/recommendations/etc on the most reliable (ie semi-enterprise at least) replication product/solution/whatever for Postgresql? I have no experience with replication on this database platform and frankly some of the packages which offer it seem a little 'dodgy' (not speaking from knowledge, just most of them don't...

I have a PostgreSQL database running under linux. Unfortunately the company has deemed it neccessary to move from Linux to Windows, so now I am tasked with moving all of the PostgreSQL database tables and stored procedures over to MSDE. The data itself can easily be recreated. The main problem is porting the structure of the existing DB over....

What database recovery systems are available in Postgres Please point me to the respective section in the documentation Thanks Sanjay Minni www.minisoftindia.com