On 11/1/05, Welty, Richard <[EMAIL PROTECTED]> wrote:
>
> Scott Marlowe writes:
> > and PostgreSQL enjoys a MUCH richer and easier to use
> >set of utilities. I find psql to be much much easier to drive than
> >oracle's SQL*PLus, which makes my head hurt.
>
> i have to use the informix dbaccess to
On 10/11/05, Dan Armbrust wrote::
> Now I'm just filling the mailing list with mis-information. It actually> ignores all but the last -t flag - so this only allows me to specify one> table at a time, rather than several tables.
There's always the low-tech option of:
for table in `cat /tmp/tabl
On 9/30/05, Emi Lu <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I am not very familiar with the system views/tables in postgreSQL. I'd
> like to get all table names that have a column let's say named "col1".
I'd use:
select table_name
from information_schema.columns
where table_schema='my_schem
On 9/15/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Sep 15, 2005 at 06:48:59PM -0400, Robert Fitzpatrick wrote:> Anyone know a package that can do this? Perferrably a Unix/Linux> package.It would be trivial to write a script in a language like Perl to
read the first line of a file and gener
On 9/6/05, Andrey Fomichev <[EMAIL PROTECTED]> wrote:
- Are there any of you who need to store and query XML data?- Do you already use PostgreSQL to store XML data or you are
just thinking about it?
The project I'm currently working on uses XML for both data extraction
from Postgres and as a mean
Jim Nasby asked:
What do people think about the Oracle method where bulk data operations
can only occur in a specified directory? Making that restriction mightaddress some of the security concerns. I don't think we should changeCOPY in such a way that you *have* to use a specified directory, but i
Wow, non-blocking lock failure?
Can I take this chance to say an overdue thanks to the Postgresql
developers? A truly commercial grade feature set in a free
database...
On 8/16/05, Matt Miller <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-08-16 at 12:01 -0700, Bill Moseley wrote:
> > I wondered if m
On 6/29/05, Zlatko Matić <[EMAIL PROTECTED]> wrote:
>
> How could I truncate, delete all content of all tables in one step ?
You could use a query to generate the statements in psql:
\t
\o trunc_all.out
SELECT 'TRUNCATE ' || table_name || ';'
FROM information_schema.tables
WHERE table_sche
On 6/16/05, David Fetter <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 16, 2005 at 07:54:29PM -, Greg Sabino Mullane wrote:
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > I recently submitted a patch that makes all the database objects
> > behave in the same way as far as the back
In the spirit of "tell us what you're trying to do..."
I'd like to mimic a subset of Oracle's Virtual Private Database
functionality (see
http://dba-oracle.com/oracle_news/2004_1_16_vpd_security.htm for an
overview) in Postgres: based on some per-connection setting, I'd like a
query to return a d
[ Sorry if this appears twice on the list: sent it via a non-subscribed email
the first time around. Of course, while waiting for it to appear I figured out
a workaround; see the "Late breaking update" at the end. ]
In the spirit of "tell us what you're trying to do..."
I'd like to mimic a su
>>> Michael Fuhr <[EMAIL PROTECTED]> 12/14/04 1:45 PM >>>
>>On Tue, Dec 14, 2004 at 11:48:21AM -0600, Kall, Bruce A. wrote:
>> What is the easiest way to copy a particular row from one table to
>> another (assuming all the columns are exactly the same). I want to
>> maintain a table ('backup_tab
In Oracle I can do this:
SELECT h.transaction_number
CURSOR(SELECT d.detail_number
FROM detail d
WHERE d.transaction_number=h.transaction_number)
FROM header h
WHERE h.transaction_date='25-aug-2004'
which comes in handy once in a while for nested parent/ch
13 matches
Mail list logo
