pqAdmin3

I've been looking though the PostgreSQL documentation but can't seem to
find a command for importing files. I read the documentation related to
large objects but this isn't what I'm looking for as I don't want to
import the entire file into a single field, I want to import it as a
table. I'm sure there's a way to do it but I can't seem to find the
magic command.

Could someone point me to (or provide) an example?

Thanks,

Ken

On Sun, 2004-10-24 at 19:25 -0400, Ken Tozier wrote:

I've been looking though the PostgreSQL documentation but can't seem to
find a command for importing files. I read the documentation related to
large objects but this isn't what I'm looking for as I don't want to
import the entire file into a single field, I want to import it as a
table. I'm sure there's a way to do it but I can't seem to find the
magic command.

Could someone point me to (or provide) an example?

Thanks,

\h COPY

The COPY command will help you with this.

-Robby

--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
****************************************/

Ken Tozier <kentozier@comcast.net> writes:

I've been looking though the PostgreSQL documentation but can't seem
to find a command for importing files. I read the documentation
related to large objects but this isn't what I'm looking for as I
don't want to import the entire file into a single field, I want to
import it as a table. I'm sure there's a way to do it but I can't seem
to find the magic command.

Could someone point me to (or provide) an example?

You want the SQL COPY statement, or the \copy command in 'psql'.

-Doug

Doug, Robby,

Thanks. That did the trick.

Ken

On Oct 24, 2004, at 8:02 PM, Doug McNaught wrote:

I'm working on a query which works as expected when I leave out one of
the "OR" tests but when the "OR" is included, I get hundreds of
duplicate hits from a table that only contains 39 items. Is there a way
to write the following so that the "WHERE" clause tests for two
possible conditions?

Thanks for any help,

Ken

Here's the working query:

SELECT a.paginator, a.doc_name, (b.time - a.time) as elapsed_time FROM
pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

When I add the OR clause things go haywire:

SELECT a.paginator, a.doc_name, (b.time - pm_events.time) as
elapsed_time FROM pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
OR a.event_code='pmop'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

Have also tried the following in the WHERE clause to no avail:

WHERE a.event_code IN {'pmcd', 'pmop'}
WHERE a.event_code=('pmcd' | 'pmop')

Ken Tozier <kentozier@comcast.net> writes:

When I add the OR clause things go haywire:

SELECT a.paginator, a.doc_name, (b.time - pm_events.time) as
elapsed_time FROM pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
OR a.event_code='pmop'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

I think you need some parentheses, or at least a bit of thought about
what the OR is binding to.

regards, tom lane

On Oct 25, 2004, at 12:35 AM, Tom Lane wrote:

Ken Tozier <kentozier@comcast.net> writes:

When I add the OR clause things go haywire:

SELECT a.paginator, a.doc_name, (b.time - pm_events.time) as
elapsed_time FROM pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
OR a.event_code='pmop'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

I think you need some parentheses, or at least a bit of thought about
what the OR is binding to.

The table stores "file open", "file create" and "file close" events
(pmop, pmcd, pmcl) What I'm trying to do is bind "open" and "create"
events to the next sequential close event for each document a
particular paginator works on. I also tried parentheses after the where
clause like so:

WHERE (a.event_code='pmcd' OR a.event_code='pmop')

But it only seems to recognize the first comparison ignoring whatever
comes after the OR

Perhaps the current authentication scheme you have set up is different
for local and remote host. It might be that pgAdmin is connecting from a
different machine? And if you're using ident authentication it might not
work from a remote machine the same as for local.

Please give more details, such as the contents of pg_hba.conf and the
way you're trying to connect from both psql and pgAdmin.

Regards,
Jeff Davis

On Sun, 2004-10-24 at 18:10 -0300, Philip Pinkerton wrote:

When trying to connect to database via the pgAdmin3 GUI it asks for a
password. I use the same passworrd as I did when I connect to the DB via
command line but I get Ident error?

how do I set, re-set the password so I can use both the commandline and
pgAdmin to access edit by DB?

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Jeff Davis <jdavis-pgsql@empires.org>

 --- Ken Tozier <kentozier@comcast.net> escribi�: 

I'm working on a query which works as expected when
I leave out one of
the "OR" tests but when the "OR" is included, I get
hundreds of
duplicate hits from a table that only contains 39
items. Is there a way
to write the following so that the "WHERE" clause
tests for two
possible conditions?

Thanks for any help,

Ken

Here's the working query:

SELECT a.paginator, a.doc_name, (b.time - a.time) as
elapsed_time FROM
pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

When I add the OR clause things go haywire:

SELECT a.paginator, a.doc_name, (b.time -
pm_events.time) as
elapsed_time FROM pm_events as a, pm_events as b
WHERE a.event_code='pmcd'
OR a.event_code='pmop'
AND b.event_code='pmcl'
AND a.doc_name=b.doc_name
AND a.paginator=b.paginator
AND a.time < b.time

Have also tried the following in the WHERE clause to
no avail:

WHERE a.event_code IN {'pmcd', 'pmop'}
WHERE a.event_code=('pmcd' | 'pmop')

the query with the OR clause says:

SELECT a.paginator, a.doc_name, (b.time -
pm_events.time)
+++++++++

meanwhile the other one says:
SELECT a.paginator, a.doc_name, (b.time - a.time)
+

Which pm_events table will the planner use a or b?? i
think in the second query you are confusing the
planner forcing a cartesian product.

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias.
Vis�tanos en http://noticias.espanol.yahoo.com