Hi:
I have a MS Access database with tables containing TEXT fields.
I need import that info in a postgres 7 table.  
How to do it? 
If I use copy from, dont work.  

tia

Carlos Jacobs

Thu, 16 Nov 2000 18:56:08 -0300
"Carlos Jacobs" <carlosjac@grupoa.com.ar>
Import text field
Carlos Jacobs wrote:
> 
> Hi:
> I have a MS Access database with tables containing TEXT fields.
> I need import that info in a postgres 7 table.
> How to do it?
> If I use copy from, dont work.

I have a perl program which will import this sort of multi-line CSV data
that is not handled by the COPY ... DELIMITER ... sort of mechanism in
PostgreSQL.

E-mail me privately if you want a copy.

Regards,
					Andrew.
-- 
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

Fri, 24 Nov 2000 21:50:32 +1300
Andrew McMillan <Andrew@catalyst.net.nz>
Re: Import text field
Hello everybody

First of all I wold like to thank you in advance because I am sure
that I would get my answer immediately.

Well I want to use nested select statements ,is it possible.
Is there any counterpart for 'Sysdate from dual' as in Oracle

with Regards

Sanjay Arora

Wed, 29 Nov 2000 20:31:07 +0530
Sanjay Arora <sk@pobox.com>
How to use nested select statements
At 08:31 PM 11/29/00 +0530, Sanjay Arora wrote:

>Well I want to use nested select statements ,is it possible.

In PG 7.0 you can use subselects in the "where" clause.

>Is there any counterpart for 'Sysdate from dual' as in Oracle

You don't need "dual", just "select now()" will work.

If you're porting Oracle code, you can make life a lot easier by
defining some stuff:

create function sysdate() returns datetime as '
begin
   return ''now'';
end;' language 'plpgsql';

create view dual as select sysdate();

Then "select sysdate from dual", "select (any expression) from dual", etc all do what
you'd expect.



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.

Wed, 29 Nov 2000 07:43:26 -0800
Don Baccus <dhogaza@pacifier.com>
Re: How to use nested select statements