Thread: Import text field

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

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

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

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
Serviceand other goodies at http://donb.photo.net.