Fernando --
It is best to always copy to the list -- more eyes means a better chance of
help.
You can use native SQL to define a database (once connected to the "template1"
database issue a "CREATE DATABASE foo;" command), or use one of the pgAdmin
option, IIRC -- I don't have it installed on
I had an offlist inquiry for more details
so I thought I would post my response.
This is a select using the union for auto xref.
SELECT distinct * FROM (
select * from viwcaselist where clientnum = 'SEA' AND DivisionID
= 100 And isdeleted=false
union all
select * from viwcaselist
In article <[EMAIL PROTECTED]>,
george young writes:
> [PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
> I have a table mytable like:
> i | txt
> ---+---
> 1 | the
> 2 | the
> 3 | rain
> 4 | in
> 5 | mainly
> 6 | spain
> 7 | stays
> 8 | mainly
> 9 |
If my database has column containing a filename, can I use sql to present
this filename and datemodified (as output from 'ls -l' or from mtime()
fuction) or *must* it be done after the query in interface such as php or perl?
---(end of broadcast)
am 11.11.2005, um 8:57:14 -0500 mailte Frank Bax folgendes:
> If my database has column containing a filename, can I use sql to present
> this filename and datemodified (as output from 'ls -l' or from mtime()
> fuction) or *must* it be done after the query in interface such as php or
You can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
> If my database has column containing a filename, can I use sql to present
> this filename and datemodified (as output from 'ls -l' or from mtime()
> fuction) or *must* it be done after the query
At 03:03 PM 11/11/05, Greg Sabino Mullane wrote:
At 08:57 AM 11/11/05, Frank Bax wrote:
> If my database has column containing a filename, can I use sql to present
> this filename and datemodified (as output from 'ls -l' or from mtime()
> fuction) or *must* it be done after the query in interface
Hi
how could I restore a db if I did next:
pg_dump -Z 9 soi > $DESTINO/soi.bkp
Thanks in advanced
Frank Bax <[EMAIL PROTECTED]> writes:
> This looks interesting! But I'm not sure how to use it?
> wbax=> select version();
> version
> -
> PostgreSQL 7.4.3 on i386-unknown-openbsd3.6, compiled by
