[ADMIN] RE: URGENT HELP NEEDED

Here is an example: CREATE TABLE membershipextras ( MemberIDint4 NOT NULL DEFAULT 0, Typechar(1) NOT NULL DEFAULT '1', GenericFieldchar(1), GenericOneToOne2int4, GenericOneToOne3

[ADMIN] RE: relation does not exist

Try: select * from "Dx"; -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 11:17 AM To: [EMAIL PROTECTED] Subject:relation does not exist I am trying to convert a MS SQL database to postgres. I have done it t

[ADMIN] RE: Outer Joins

The current source (7.1 beta 4, I think) has support for outer joins and they work great! -Original Message- From: Steve Doerr [SMTP:[EMAIL PROTECTED]] Sent: Saturday, February 03, 2001 7:37 PM To: [EMAIL PROTECTED] Subject:Outer Joins I saw that outer joins will be supp

[ADMIN] RE: Admin tutorials?

In psql, type \dS. This will report all the system tables. For example: Select * from pg_tables; Will select info on all your tables. Here is a link that describes most of the system tables: http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm -Original Message- Fro

[ADMIN] Numeric and money

al functions that already exist to convert numeric to text so that I don't have to write one? I know that psql successfully does this. Thanks, Michael Davis Database Architect and Senior Software Engineer, Seva Inc. Office: 303-460-7360Fax: 303-460-7362 Mobile: 720-320-6971 Email: [EMAIL PROTECTED]

[ADMIN] RE: pg_dump/psql < db.out issue

. -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 9:45 AM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject:Re: pg_dump/psql < db.out issue Michael Davis <[EMAIL PROTECTED]> writes: >

[ADMIN] pg_dump/psql < db.out issue

ea how to work around this other than using the -d/-D option in pg_dump? I like the -d option in pg_dump, however, importing the data via pgsql is much slower with this option. Thanks in advance, Michael Davis

[ADMIN] Removing a constraint?

Does anyone know how to completely and accurately remove or drop a constraint, specifically a foreign key constraint? I tried to remove a constraint by deleting it's trigger from pg_triggers. This caused some undesirable side effects with other tables involved with the constraint. I have se

RE: [ADMIN] 8k tuple limit - i want it higher!

Check the psql-hackers archive. I know this topic, how to do this, and concerns about this was addressed 2-4 weeks ago. -Original Message- From: JT Kirkpatrick [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 13, 1999 12:51 PM To: '[EMAIL PROTECTED]'

[ADMIN] 6.4.2 RPM's for Red Hat 5.2 Linux

How do you keep the 4 databases in sync with each other? -Original Message- From: Eric Lee Green [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 12,