Is it possible to setup a trigger so that every time a
certain field is changed, an email is sent? Using
pl/pgsql.
Thanks,
CSN
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
cd src/pl/plphp
make && make install
I get this error:
cp @php_path@/main/php.h ./
cp: cannot stat [EMAIL PROTECTED]@/main/php.h': No such file
or directory
make: *** [patch] Error 1
Know what the problem is?
Thanks,
CSN
__
libperl.so: cannot
open shared object file: No such file or directory
plperl.so does exist in /usr/lib/postgresql
(libperl.so does not). I also compiled in plpython,
and createlang appeared to work for that. Any idea
what the problem is?
Thanks,
CSN
_
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > createlang: language installation failed: ERROR:
> > could not load library
> > "/usr/lib/postgresql/plperl.so": libperl.so:
> cannot
> > open shared object file: No
t of) backslashes in the python code then the
function gets created fine.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)-
Nevermind, I see dollar-quoting was added in 8.0.
--- CSN <[EMAIL PROTECTED]> wrote:
> Can dollar quoting be used with plpythonu (like with
> plperl -
>
http://www.postgresql.org/docs/8.0/interactive/plperl.html#PLPERL-FUNCS)?
> When trying to create a function I get this e
When accessing Postgres boolean fields (in the TD
dictionaries) in plpythonu, their values are '0' or
'1'. IIRC, in PHP their values would be 't' or 'f'.
How are boolean values actually stored in Postgres?
CSN
Discover Yahoo!
Stay in
I like Postgres's boolean type - why do you suppose
neither Mysql nor Oracle has bothered to implement it?
Booleans are in the SQL-99 spec.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yaho
le 10 has a bit
> data type (which is a
> boolean for all intents and purposes):
Could a bit handle NULL's though?
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
e[1]: *** [all] Error 2
make[1]: Leaving directory
`/usr/local/src/postgresql-8.0.2/src'
make: *** [all] Error 2
Know what the problem is?
Thanks,
CSN
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
-
I'm installing PG8 for Windows and the default locale
is "C" in the installer. What is locale C?
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---
Is it possible to have the database name, datetime,
and maybe even the query itself show up in pgsql's
error log?
Thanks,
CSN
__
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/reso
n. Any idea what the problem
is?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: the planner will i
..
"""
server = smtplib.SMTP("localhost")
server.set_debuglevel(1)
server.sendmail(fromaddr, toaddr, msg)
server.quit()
#
I also recently switched to Dbmail, so maybe that
caused a problem (but mail works fine with everyt
Ah, you're right. The function appears to only cause
an error on inserts and not updates. Thanks for
pointing that out (I'm really green at Python).
CSN
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, May 25, 2005 at 12:02:22PM -0700, CSN wrote:
> >
> >
d use? I'm using PHP for the
trigger (and PG 8.x).
Thanks,
CSN
PS - Scott and I have been tossing around a few other
ideas here:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10302693
Yahoo! Sports
Rek
If I have a table of items with latitude and longitude
coordinates, is it possible to find all other items
that are within, say, 50 miles of an item, using the
geometric functions
(http://www.postgresql.org/docs/8.0/interactive/functions-geometry.html)?
If so, how?
Thanks,
CSN
Is it possible to dump specific function definitions
using pg_dump? Any other items that can be
specifically dumped, besides just tables?
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r
_catalog.cstring'::pg_catalog.regtype
AND p.proargtypes[0] <>
'pg_catalog.cstring'::pg_catalog.regtype
AND NOT p.proisagg
AND
pg_catalog.pg_function_is_visible(p.oid)
AND p.proname ~ '^+$'
ORDER BY 1, 2, 3, 4;
I
a user for a specific database? All I'm familiar with
is "alter user joe createuser." Or is there a better
way of handling this language and permission issue?
(The function uses mail(), so IIRC that necessitates
using plphpu).
Thanks,
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > I'm using plphpu and I'd like to allow the regular
> > database user to use it, but since it's
> "untrusted" it
> > requires users to be superusers. If I h
nience! I want the email sent whether the member
is added via the web interface, directly in the
database, from the command line, etc. I don't see any
downside. It's only one user that'll be using this
function.
CSN
__
Do You Yahoo!?
with a small script
> which
> basically LISTENs to notify from database, spools
> the
> mails and go sleep again.
Could you elaborate how you do this? IIRC, there's an
example in the docs using C, but I'd prefer using a
scripting language.
Thanks,
CSN
Is it possible to have PG report the actual number of
rows that actually CHANGED in an update command? e.g.
UPDATE items set name=replace(name,'abc','def');
UPDATE 9000 -- Actually only 3 were changed
rather than update reporting all rows have been
&qu
PG's docs on notify say that if events
happen in rapid succession, notify's might get
dropped. For example: could many item rows get
deleted, but some of their corresponding files not get
deleted due to dropped notify's?
Thanks,
CSN
ied that plphp (and plphpu) is installed
with 'createlang -l'.
Any idea what the problem is?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-reference, you
can set allow_call_time_pass_reference to true in your
INI file. However, future versions may not support
this any longer. in plphp trigger call on line 1
Is there anything I can do about it? I'd email plphp's
list, but their mailing list links a
Nevermind, I found some stray single quotes (in an
array var) in a double-quoted string that appears to
have been the problem.
--- CSN <[EMAIL PROTECTED]> wrote:
> I'm using plphp to create a trigger. I don't see any
> syntax errors in it (I've checked it with php -l
reset: Failed.
And this is what shows up in the log:
LOG: server process (PID 31665) was terminated by
signal 11
LOG: terminating any other active server processes
Wow. I still don't see anything wrong with the plphp
function - how could it cause the entire server to
crash?
Thanks
Jeez, nevermind again! Turns out this was the problem
in the plphp script:
$sql="select * from table where id=123";
$result=spi_exec_query($sqll);
I'm still curious about the "Call-time
pass-by-reference has been deprecated" warning if
anybody knows.
Thanks,
CSN
I'm using PHP5, and I'm not passing by reference. My
first stop WAS plphp.commandprompt.com, but none of
their mailing list links for plphp work.
CSN
> # jd ( at ) commandprompt ( dot ) com / 2005-08-11
15:45:18 -0700:
> > Roman Neuhauser wrote:
> > ># cool_screen_
$message=<<";
mail($to,
"Link Activated - $group[name]!",
$message,
"From: {$group[name]} <$group[email]>\r\n");
}
}
}
$$ LANGUAGE 'plphpu';
-- CREATE TRIGGER email_activated_member AFTER INSERT
or UPDATE ON links
og. I'd guess maybe it's something
plphp is doing on its own with references, but I
should probably play around with some more plphp
functions and see if they generate the same warnings.
Anyhow, thanks for the help.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Greetings-
How can I remove tsearch2 (all its tables, types,
functions, etc.) from a database?
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of
In a field I have text like "in today's news..." When
I select that field in psql using putty (Latin-1),
then apostrophe doesn't show up (shows up as
"todays"), but it does show up in phppgadmin (and
other php programs). Is this an issue with psql, or
putty (or
ls ..
--- Richard Huxton wrote:
> CSN wrote:
> > In a field I have text like "in today's news..."
> When
> > I select that field in psql using putty (Latin-1),
> > then apostrophe doesn't show up (shows up as
> > "todays"), but it does sh
n the database.
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 3: Have you checked our extensiv
Ah, it's Western ISO-8859-1. Putty has the same
setting. I tried changing putty's charset to UTF-8 and
now curly apostrophes are displayed as a grey box in
psql's output (e.g. "in today[box]s news...").
Thanks,
CSN
--- Richard Huxton wrote:
> CSN wrote:
> >
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Aug 15, 2005 at 12:14:16PM -0700, CSN wrote:
> > Is there a way to replace all curly apostrophes
> with
> > standard apostrophes (presumably with
> replace(x,y,z))?
> > My database is SQL_ASCII and I can't
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Aug 15, 2005 at 01:48:00PM -0700, CSN wrote:
> > db=>select ascii('');
> > ascii
> > ---
> >226
> >
> > db=>select id from news where body ilike '%%';
> &
x27;2001-09-28' + ((7+7)||' seconds')::interval);
etc.
Or am I missing an easier way to do date arithmetic
using a table's fields as part of the equation? (I
think mysql has date_add(...), date_subtract(...),
etc.
CSN
__
Do Yo
a way to rewrite
this query so the index is used?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t that was in cygwin/path - what's the
remedy to get \s to work?
BTW, is there a way to set the number of commands
returned by "\s"?
Thanks,
CSN
Start your day with Yahoo! - make it y
For lack of a better term, but I was curious if there
is/was any thought about making PG's views
automatically "see" changes in underlying tables, as
opposed to currently having to drop/create all
corresponding views if a table's structure (add/delete
fields, et
y row (and subsequently
be able to delete that row's files), or will only one
notify event be received (or some number less than the
actual number of rows deleted)?
Thanks,
CSN
Start your day with Yahoo!
er or not there is a transaction in
progress.)
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> CSN wrote:
> > Perhaps another possible feature request! I've
looked
> > through the docs and it doesn't appear that it's
> > possible to create deferred triggers - i.e. they
don't
> > get called unless the current transaction commits.
rmine what data types
each field should be?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
Just something I was curious about - is there any
difference at all between "character varying" (in the
SQL spec) without a length specified and "text" (not
in the SQL spec)?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editor
e the
database automatically handle this (trigger to compute
hash field at insert time - unique index will raise an
exception).
Thanks for any help, insights, suggestions, etc.
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.
, 2713
CONTEXT: SQL statement "insert into stuff (title,
yield, directions) values ( $1 , $2 , $3 )"
What do I do?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(e
--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-09-21 at 15:02, CSN wrote:
> > This appears related to my previous post:
> >
>
http://archives.postgresql.org/pgsql-general/2005-09/msg00809.php
> >
> > I setup a unique index using the title, yi
I have a table that relates id's of two other tables:
table1id, table2id
Dupes have found their way into it (create unique
index across both fields fails). Is there a quick and
easy way to find and delete the dupes (there are tens
of thousands of records)?
Thanks
Nevermind, figured it out:
select distinct on (table1id, table2id) * into temp
from table3;
delete from table3;
insert into table3 select * from temp;
--- CSN <[EMAIL PROTECTED]> wrote:
> I have a table that relates id's of two other
> tables:
>
> table1id, table2i
d it using WinXP's command prompt and none
of the function keys cause psql to segfault.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(e
Here's what 'od -c' shows for F1-4:
^[OP^[OQ^[OR^[OS
CSN
--- Bruce Momjian wrote:
> CSN wrote:
> > If I'm in psql (via putty, from WinXP to Redhat)
> and
> > hit F1-4 (F5+ just display a ~), psql will
> > segmentation fault and exit. Not that I&#x
I did 'strace psql dbname' and this was the output
after hitting F1:
read(0, "\33", 1) = 1
read(0, "O", 1) = 1
read(0, "P", 1) = 1
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ k
Hmm, all I could think of was perl and php - hitting
F1-4 just caused these chars to be displayed (the
interpreters didn't exit):
^[OP^[OQ^[OR^[OS
CSN
--- Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian writes:
> > > CSN wrote:
> > >> If I&
It looks like I had readline 4.3 installed. I just
installed readline 5.0 - the F1-4 keys still cause
psql to segfault. (AFAIK I don't need to recompile
postgres for psql to use the newly installed
readline).
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTE
here are also options for
"VT400", "VT100+", and "SCO" - haven't tried those).
Thanks,
CSN
--- Klint Gore <[EMAIL PROTECTED]> wrote:
> On Sun, 25 Sep 2005 20:00:03 -0700 (PDT), CSN
> <[EMAIL PROTECTED]> wrote:
> >
> > I did 'strace psq
Just so I know (and am armed ;) ), are there any new
comparable features in MySQL 5.0 that aren't in
PostgreSQL up to the forthcoming 8.1? AFAIK, PG just
lacks updatable views (which are on the TODO).
MySQL 5.0 new features
http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html
Thanks
I'm not sure what XA (distributed transactions) is -
is that something that can be achieved with Slony?
CSN
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-10-05 at 18:37 -0700, CSN wrote:
> > Just so I know (and am armed ;) ), are there any
&g
I consider "select as" to be
really trivial (and it appears a work-around can be
hacked).
- lowercase folding. I DO sometimes wish I could use
fieldID, etc. without quoting it.
- I've never found count(*) to be slow.
- I don't know enough about the "UNICODE me
ble partitions? Or
Slony?
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-10-05 at 23:41, Tom Lane wrote:
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > > On Wed, 2005-10-05 at 18:37 -0700, CSN wrote:
> > >> Just so I know (and am armed ;) ), are the
--- CSN <[EMAIL PROTECTED]> wrote:
> - 8 of the 13 are for versions of PostgreSQL <= 8.1
Doh!
- 8 of the 13 are for versions of PostgreSQL < 8.1!
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
h
Yep, I think the SQL spec says fold to uppercase. I'm
not sure why PostgreSQL folds to lowercase instead,
but if folding has to occur, I prefer lowercase.
CSN
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Thu, Oct 06, 2005 at 12:54:43PM -0700, CSN wrote:
>
I had a similar experience speaking to the MySQL folks
at (the last) COMDEX. After trying to get them to
explain how their licenses work, I was even more
confused (and two reps even gave conflicting info).
CSN
> Hi everyone,
>
> I've just got back from LinuxWorld in London a
AP
# InnoDB
# BDB or BerkeleyDB Tables
# Example
# Archive
# Federated
# CSV
# Blackhole
# NDB Cluster
http://dev.mysql.com/doc/mysql/en/storage-engines.html
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it
dows XP. This computer has been crashing repeatedly
lately, if that could be blamed (bad memory? hard
disk? I haven't quite figured out why.) Using
phppgadmin, I was able to delete one of the duplicate
rows (there are several) - don't know how i
Look what somebody suggested!
---
If the worst happens and Oracle tries to squash
InnoDB, there may already be such an alternative out
there.
I wonder what it would take to add (and optimize)
Postgres storage engine support to MySQL? I don't know
exact
Yep, those were two of my very first questions too. ;)
CSN
--- "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
> Stupid question, but what does MySQL bring to the
> equation? Why not just
> use PostgreSQL in the first place?
>
> On Sun, 9 Oct 2005, CS
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sun, Oct 09, 2005 at 12:46:51PM -0700, CSN wrote:
> > select * from table1 where id=586;
> > 586|a|b|c|d
>
> Do you get different results from the following
> queries?
>
> SET enable_seqscan TO on;
> SET e
o determine how badly it lies. ;)
Thanks,
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > oid | ctid| xmin | cmin | xmax |
> cmax | id
> >
>
+---+-+--+-+--+-
> >
If integer's range is -2147483648 to +2147483647, why
is serial's range only 1 to 2147483647 instead of 1 to
about 4294967294?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > If integer's range is -2147483648 to +2147483647,
> why
> > is serial's range only 1 to 2147483647 instead of
> 1 to
> > about 4294967294?
>
> How are you goin
tries table are return (I expected an error). Is
this the "implicit FROM" gotcha?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
---
There are some articles on eweek about this:
Oracle Finds the Flaw in MySQL's Business Plan
http://www.eweek.com/article2/0,1895,1869989,00.asp
"This is what Oracle says in its release: "InnoDB's
contractual relationship with MySQL comes up for
renewal next year. Oracle fully expects to negotiate
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
Thanks,
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unli
I don't know if I'm going to get a copy of
pg_filedump. What's the best way to fix this - dump
then restore?
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > oid | ctid| x
perhaps NULL's in OLD.stuff is
causing the IF to behave other than what I expect.
Thanks for any help!
CSN
CREATE or REPLACE function update_ts() returns trigger
as $end$
BEGIN
IF (TG_OP='UPDATE') THEN
IF (OLD.stuff != NEW.stuff) THEN
UPDATE tabl
s NOT NULL) or
(OLD.value != NEW.value)) THEN
--
END IF;
So, does NULL != 'abc' always evaluate to false? The
manual
(http://www.postgresql.org/docs/8.0/interactive/functions-comparison.html)
states don't compare NULL values using =, but nothing
BTW, it (the SQL spec I presume) has always seemed
contradictory to me that you can't do:
select * from table where field=null;
but can do:
update table set field=null;
(as opposed to 'update table set field to null' or
ith potentially different sizes)?
Thanks,
CSN
__
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---(end of broadcast)---
TIP 4: Have you searched ou
nice comes to mind:
nice pg_dump ...
On Sat, 2005-10-22 at 07:39, Bryan Field-Elliot wrote:
> We have a huge database which must be backed up
every day with
> pg_dump. The problem is, it takes around half an
hour to produce the
> dump file, and all other processes on the same box
are starved f
Here are some apparent problems with MySQL 5.0:
- Concurrent ALTER TABLE
- Replicated Session Variables and Concurrent ALTER
TABLE
- BIT indexing that [doesn't] actually uses a BIT!
- SELECT * FROM FOO WHERE ID IN ( SELECT FOO_ID FROM
BAR ) [doesn't use index]
http://www.feedblog.org/2005/10/what
,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choo
omatically access the sequence. I don't like this
as it may break other things. Is there a way to create
an alias or something (e.g. quotes_seq_id points to
quotes_table_seq_id), or is there a better way?
Thanks,
CSN
__
Yahoo! Mai
pg_get_serial_sequence(
> 'table','col' ) );
I like that better than the current 'table_col_seq'.
Perhaps just currval('table', 'col'). Or perhaps
tables could be made to have a default sequence (one
that's associated with the primary key).
CSN
err'). Any way to further diagnose this?
thanks
csn
__
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t; Having defended the undefendable, however, I'd
like to know if
> > postgresql really still doesn't support Unicode on
windows, as
> > I plan to develop on WindowsXP and deploy on
Linux.
> >
> > Warren Seltzer
Thread here:
http://www.ruby-forum.com/topic/3690#new
s
after changing a
table's schema? I don't know how something is trying to set members.admin to
null (table members
has no triggers).
thanks
csn
Postgresql 8.0.x
__
Yahoo! FareChase: Search multiple travel sites in one click.
http://fa
h, and now
they both appear to
function properly. I don't remember seeing anything in the docs stating that
this is necessary, so
I guess perhaps it's a bug?
csn
--- CSN <[EMAIL PROTECTED]> wrote:
> I have a members table and an items table. Every time items.member_id or
I have two tables:
items: id, title, added, ...
news: id, headline, datetime, ...
I'd like to select the latest 25 combined records from both tables. Is there a
way to do this
using just select?
Thanks,
csn
__
Do You Yahoo!?
Tired of
PostgreSQL doesn't have any booth babes? ;P
csn
> On 09/20/06 16:38, Philip Hallstrom wrote:
> [snip]
> > I think that description is false. At a certain point in the
> > management hierarchy, the only way anyone has the ability to
> > evaluate something is on t
ional things (if so, please describe how they'd also be dumped)?
Thanks,
csn
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates
(http://voice.yahoo.com)
--
Any chance of changing \copy and COPY to allow
specifying what the fields are enclosed by (such as
quotes) and to ignore the first x number of lines? I
have data like below and don't know of an easy way to
finesse it for importing (a simple regexp would remove
quotes, but I just got tripped up on c
Ah, looks like "enclosed by" will be in PG 8 :). Is
"QUOTE [ AS ] 'quote'" for the "enclosed by"
character?
Ignore x lines would be nice, but not as big of a
deal.
http://developer.postgresql.org/docs/postgres/sql-copy.html
--- CSN <[EMAIL PROTECT
Just wondering - does PG support derived tables? I'm
not really sure what the difference is between them
and subqueries.
http://www.mysql.com/news-and-events/press-release/release_2004_32.html
http://www.sqlservercentral.com/columnists/rmarda/derivedtablebasics_printversion.asp
1 - 100 of 170 matches
Mail list logo
