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 tool here at
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
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_schema'
and
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 generate
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 means
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
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 my
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
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 backslash psql
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
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_table') that has
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
12 matches
Mail list logo
