On 17 Oct 2001, Arcady Genkin wrote:
> What I want is an SQL equivallent of "\ds" command, which will return
> a list of all sequences in the current database. I need this for a
> periodically run script so that I could keep an eye on all sequences
> in the database.
\ds *is* the psql command f
On 17 Oct 2001, Arcady Genkin wrote:
> Where does Postgres store information about the sequences? I tried
> looking in the tables produced by "\dS", but could find no references
> to the sequences. :(
Oops, I thought you had made a typo, but I made a thinko. Use the -E
option to generate the S
On Thu, 18 Oct 2001, [iso-8859-2] Micha³ 'Samuel' Modestowicz wrote:
> I know that my question may seem trivial, but unfortunately I haven't found
> any understandable info on this topic. It's about length limit of the TEXT
> field in PostgreSQL. I've heard that the TEXT fields in psql are limite
On Fri, 19 Oct 2001, Mark Muffett wrote:
> Is there a simple query to return the column names used in a table?
If you start up psql with the -E option, and then do \dt , it
will spit out the SQL used to retrieve the metadata on your table. You
can use that as your basis.
-- Brett
On Thu, 18 Oct 2001, Rich Shepard wrote:
> Just in case I mis-typed at the command line, I just tried the above. Same
> error: cannot find database system (in /var/lib/pgsql/data, where it is)
> and failed looking for /var/lib/pgsql/data/global/pg_control.
>
> The problem is that the file, pg
On Thu, 18 Oct 2001, Michael Coughlin wrote:
> The docs say to startup, using postmaster -i (Internet?) switch - for TCP/IP
> use. They don't elaborate on where to properly implement postmaster -i.
Have you read the administrator's manual? It gives tips on what to put
into start up scripts.
>
On Fri, 19 Oct 2001, Flávio Brito wrote:
> I am using "pg_dumpall -h localhost -p 5432 > db.out"
> When I try it on Windows its turns my printer on and freeze
Ouch! What version of Windows are you using? I seem to recall that DOS &
Windows used to remap an interrupt (divide by zero? overflow
On Fri, 19 Oct 2001, Andy Hallam wrote:
> I am porting our applications from SQL SERVER, ORACLE and DB2 to PostgreSQL.
>
> I have just read that PostgreSQL does NOT support cross-database queries.
Nope, it doesn't. However, you can simulate this in your client
application by having two database
On Fri, 19 Oct 2001, Rich Shepard wrote:
> Should I move configuration files (such as pg_hba.conf) to a safe area,
> then manually delete all references to postgres that locate and find reveal,
> before starting from scratch?
A good idea. I usually back up all of my databases (if required) an
On Fri, 19 Oct 2001, Rich Shepard wrote:
> Thanks. Other than pg_hdb.conf, what files do I save?
Save all of your conf files, and probably pg_control & pgpasswd also. If
you have data, you should also do a database dump so you can restore it.
Take a look at the administrator's manual also.
table scans, but it cannot handle the complex structures that
> > Pgsql can. Pgsql has scads of additional features, but is limited
> > in platform support compared to mysql.
>
> Huh? You caught my eye on this one ... what platform are we missing? :(
Actually, I daresay Postgre
atforms (except for OS/2).
Brett W. McCoy
http://www.chapelperilous.net
---
Hello. Jim Rockford's machine, this is Larry Doheny's machine.
are and run
> Win9x in a window on your Linux partition to test Win9x apps if you must run
> Win9x.
>
> Or, port Cygwin to Win9x so that PostgreSQL can run on Win9x.
CygWin does run on Windows 9x, doesn't it? Or at least it used to!
Brett W. McCoy
On Mon, 29 May 2000, Ron Chmara wrote:
> > > Well, you have binaries for NT, but what about home users/developers on 95? 98?
> > > mySQL even does OS/2. Really.
> > But you have to pay money to run it on those platforms (except for OS/2).
> > Brett W. McCoy
>
On Tue, 30 May 2000, The Hermit Hacker wrote:
> On Mon, 29 May 2000, Brett W. McCoy wrote:
>
> > On Mon, 29 May 2000, Ron Chmara wrote:
> >
> > > > Huh? You caught my eye on this one ... what platform are we missing? :(
> > >
> > > Well, you
;
> >
> > The documentation references using MVC++.
>
> We support WIn95/98 clients, not servers.
My mistake.
Brett W. McCoy
http://www.chapelperilous.net
---
#x27;);
However, take a look at using sequences (which is what the serial type
uses underneath). They can give you a good bit of flxibility in terms of
starting and ending numbers, amount of increment, and so on.
Brett W. McCoy
On Sun, 10 Dec 2000, Matthew wrote:
> > I think MySQL got a big start by migrating mSQL users years ago and
> > having a compatibility module for mSQL.
> >
> [Matthew] Would it make sense for postgre to have a mysql
> compatibility module? An add on package (perhaps in contrib) that would
On Mon, 11 Dec 2000, Matthew wrote:
> > I agree that the key developers shouldn't spend much time on such a
> > thing, but on the other hand this isn't a project that requires a key
> > developer to get done. If Matthew or someone else feels like spending
> > time on it, I wouldn't object...
> >
On Thu, 7 Dec 2000, Travis Bauer wrote:
> How would I write an sql statement which would select all the
> records from a table where some string field contains
> some substring? Example: find all the records where f1 contains
> the world "cool."
SELECT * FROM mytable WHERE f1 LIKE '%cool%';
or
On Thu, 14 Dec 2000, Soma Interesting wrote:
> I'm using PHP & PostgreSQL.
>
> All values called from the database are still padded with extra spaces from
> the column size in the database. Is this normal - I don't remember this
> happening when I was using MySQL. I thought usually the database s
On Mon, 18 Dec 2000, Brian C. Doyle wrote:
> I have a file that I am trying to import/copy into a table. The problem
> that I am having is that there are carriage returns through out the
> document. These carriage returns should be copied into the column it
> belongs to yet during the
> copy ta
On Mon, 18 Dec 2000, Brian C. Doyle wrote:
> Okay now I am an Idoit. How do I tell what is used for the carriage
> return? I know how to make the replacement I just can not tell they
> characters used.
Are you on Windows, Unix or Mac?
-- Brett
http://www.c
On Tue, 19 Dec 2000, Harry Wood wrote:
> Anyone know how to create auto incrementing fields?
create sequence my_seq;
create table my_table (
my_id integer primary key default nextval('my_seq'),
another_field varchar(10),
...
);
OR, you can create an implicit sequence:
On Tue, 26 Dec 2000, Bruce Momjian wrote:
> > See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
> > SERIAL type.
> >
> > [An aside: this is something definitely that qualifies as a frequently
> > asked question, as this is like the 4th time in a week this question has
>
On Wed, 27 Dec 2000, Bruce Momjian wrote:
> > Perhaps not -- this is what I am wondering. Is it sent to subscribers as
> > part of a welcome message? At any rate, this particular question I think
> > has now qualified for the FAQ, at the very least! Or maybe even a section
> > in the FAQ for p
On Wed, 27 Dec 2000, Tom Lane wrote:
> At one time Marc was arranging for the list bot to append automatic
> tags to all postings. I'd be in favor of an automatic tag that read
> something like
>
> list administrivia: [EMAIL PROTECTED]
> Postgres FAQs: http://...
>
>
On Tue, 2 Jan 2001, Ed Loehr wrote:
> I have a table created like so:
>
> CREATE TABLE foo (
> id INTEGER NOT NULL
> ...
> );
>
> I need to alter the table to get rid of the "NOT NULL" constraint on the
> 'id' column. Can I do this using ALTER TABLE? Or d
On Wed, 3 Jan 2001, Peter Eisentraut wrote:
> > I'm baffled by what seems to be a lack of detailed documentation for
> > something so fundamental as the built-in functions.
>
> Just to add a particular point, in addition to Vince's excellent general
> points, as the one who was last to update the
On Sat, 6 Jan 2001, George Johnson wrote:
> So basically, I've wiped all my databases, it looks like, and no, there is
> no directory/structure which atomically can be called "your database", other
> than the ENTIRE data/base directory.
Sure there is -- under my $PGHOME/data/base, each separate
On Sat, 6 Jan 2001, Tom Lane wrote:
> Yeah, but those files are only half the truth. The other half lives in
> pg_log and the installation-wide tables (pg_database, etc). George is
> correct: you cannot recover using only the contents of $PGDATA/base/foo.
> You really need all of $PGDATA.
Real
On Sat, 6 Jan 2001, Robert B. Easter wrote:
> What is the syntax for this? Is there an example I can see/run?
Should follow standard SQL92 syntax (which, BTW, Oralce doesn't):
SELECT * FROM table1 LEFT OUTER JOIN table2 ON (table1.field =
table2.field)
This will return all rows from table1 ev
Dangling large objects? I thought this was a family list. :-)
-- Brett
PS. Sorry, couldn't resist...
http://www.chapelperilous.net/~bmccoy/
---
Unnamed Law:
If it happens, it mu
On Sun, 14 Jan 2001, Stephan Szabo wrote:
> I believe there was discussion about these things on -hackers a while
> back. The type promotion and which type a constant is seen as is kind of
> wierd right now. The query will probably work with explicit typecast to
> numeric for the constants.
Ye
On Tue, 16 Jan 2001, Ned Lilly wrote:
> Anyone heard about this?
>
> http://no.spam.ee/~tonu/mysqlfs.html
That only confirms the criticisms that some have leveled at MySQL of being
an SQL interface to a filesystem and not a true relational database
management system.
-- Brett
On Wed, 17 Jan 2001, Uro Gruber wrote:
> I want to know how to edit this file. Because is only for reading. Is
> there any program to edit this. For now i chmod it to 600
> end edit with my editor.
That's the way you are supposed to do it! Just make sure you make it
read-only after you are done
On Fri, 19 Jan 2001, mg wrote:
> I have troubles with jsp-based websites that have been generated by
> Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the
> problem lies in the JDBC driver not supporting prepareCall (prepareCall
> throws the PSQLException "postgresql.con.call" inst
On Fri, 19 Jan 2001, Matthew Taylor wrote:
> Umm I must have missed it in the manual, (read it 3-4 times tho) but what is
> the equivalent data dictionary structure in Postgres to the following in
> Oracle.
>
> Select table_name from user_tables;
>
> (gives a list of the table names in the databa
On Sat, 20 Jan 2001, Tom Lane wrote:
> > currval returns error unless nextval has been called at least once in the
> > session.
>
> > I use .last_value
>
> > Perhaps I'm fooling myself
>
> Yes, you are, unless you never have more than one client attached to
> your database. last_value will retur
On Wed, 24 Jan 2001, Tom Lane wrote:
> Something I'm curious about: does MySQL support user-defined datatypes?
No, it does not.
> If so, how hard is it to make a new datatype? I think datatype
> extensibility is one of the cooler features of Postgres ...
Check this out:
http://www.mysql.com/d
On Wed, 24 Jan 2001, Peter Eisentraut wrote:
> David Wall writes:
>
> > Now that MySQL has transaction support through Berkeley DB lib, and it's
> > always had way more data types,
>
> I count 25 documented and distinct data types for MySQL, and 30 for
> PostgreSQL.
Not to mention that Postgres
On Wed, 24 Jan 2001, Raymond Chui wrote:
> I also have a HP machine with OS HP-UX 10.20, I have installed
> Perl 5.6 and DBI. But when I install DBD (DBD-Pg-0.95) it requires
> me install all those *.h files and libpg.* files first. I don't want to
> install PostgreSQL server in the HP machine, I
On Wed, 24 Jan 2001, Alexander Klimov wrote:
> I need to store XML documents in database, so I use large objects for
> them. Now I have a problem: I want to search for patterns in documents,
> and it looks like there is no standard way to do it, so I write
> C function to do it, but it has limita
On Thu, 25 Jan 2001, Gilles DAROLD wrote:
> Don't forget to use Apache::DBI on top of DBI.pm. See mod_perl
> documentation
> for a complete setting.
Apache::DBI is supposed to be supporting connection pooling in the near
future.
-- Brett
http://www.chapelper
On Tue, 30 Jan 2001, Jeff wrote:
> I have a design question. Lets say we want to keep track of users and
> their respective snail mail addresses. Each user can have up to 4
> different mailing address. Is it better to have all this information in
> one table. Or is it better to have a user tab
On Wed, 31 Jan 2001, Dan Wilson wrote:
> I wouldn't call PHP a subset of Perl at all! I'd call them sibling
> languages with different strengths. I think Perl does certain things better
> than PHP but PHP has strengths that Perl probably can't compete with. But
> for the most part, AFAIK, anyt
On Tue, 6 Feb 2001, Tressens Lionel wrote:
> I am the super user of my DBMS and if create a database for a simple user,
> I do :
>
> => create database formyuser;
>
> But If this user connects to the database and tries to create a table, he
> has no rights. I must (the super user) create the tabl
On Thu, 8 Feb 2001, Brice Ruth wrote:
> Its not working ... I looked at the admin docs and edited the pg_options
> file appropriately ... the following is what appears in /var/log/messages:
>
> postgres[23686]: read_pg_options: verbose=2,query=4,syslog=2
>
> But no queries ... I sent SIG_HUP to p
On Fri, 9 Feb 2001, Oleg Lebedev wrote:
> I am using postgresql to store data passed from a web page. A user may
> enter whatever text she wants on that web page. Do I have to prepend all
> the illegal characters in the text with backslashes before storing the
> text in the database? Is there any
On Sat, 24 Feb 2001, Bela Lantos wrote:
> I just started learning Database Design, our programs have to work on
> Oracle, but at home I run Linux.
>
> Can any of you tell me how portable are the programs written for Progresql?
> Would they run on Oracle without problem?
That all depends on the p
On Tue, 6 Mar 2001, Chris wrote:
> >Is it really necessary to use PHP and ODBC? PHP has a native postgresql
> >interface I believe...
>
> It sounds like the postgres server is a different machine to the web
> server, so ODBC is needed to communicate between the 2..
No it isn't. Postgres should
On Mon, 5 Mar 2001 [EMAIL PROTECTED] wrote:
> I know this issue has been discussed, currently I can't find the
> resolution. What needs to be done to the latest php release to get it
> to successfully compile with the latest beta version of pgsql?
It can't find the postgresql headers. Did you
On Sun, 11 Mar 2001, Russell Hires wrote:
> I have a question. I'm
> currently running version 7.0.3 (compiled myself using debuild) on
> debian-m68k potato. When I start psql, my prompt doesn't look like every
> example I've seen. The examples are like this: "mydb=>" My prompt looks like
> this:
On Sun, 25 Mar 2001, Christian Marschalek wrote:
> I can't find the desciption of "views" in the PostgreSQL docs.
> Could somebody please point me out or explain database views to me?
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createview.htm
This is a good start to see how they ar
On Mon, 26 Mar 2001, Scott Gritton wrote:
> I've installed postgresql on a Linux-Mandrake 7.0.2 box with everything
> installing correctly.
> But when I try to start postmaster I get the following:
>
> DEBUG: Data Base System is in production state at Mon Mar 26 (and so forth)
>
> I know that the
On Sat, 14 Apr 2001, Jan Wieck wrote:
> Is it allowed to borrow the Cristian rules even if I don't
> believe in God and don't pray? Do they fall under the GPCL
> (General Public Christian License) or are they distributed
> under a BSDish style license? What if I link myse
On Sat, 14 Apr 2001, Stefan Waidele jun. wrote:
> How specific is BCE?
> 1973 Before the Current Era my birth year,
> but _only_ under that very pro-christian
> assumption that BC = BCE !
This brings up another question nto related to religion but just time
keeping in PostgreSQL: can PostgreSQL
On Tue, 9 Mar 1999, amarof wrote:
> please give me the way to do that
> all thanx
It would help a little if you mentioned what you are running PostgreSQL
on. Different systems have different kinds of startup scripts.
Brett W. McCoy
allow me some way of automating the conversion of the mdb table
> structures into postgres short of recreating the tables from scratch in
> postgres.
Have you lokked at pgAdmin? it has utitilities for migrating Access files
to PostgreSQL.
Brett W. McCoy
oy and even
> > set database permissions for other users.
>
> Also, don't you have to set up Postgres to accept users from another
> machine.. I forget exactly where you do that.
That'd be the pg_hba.conf file, and you can set up everything from IP
based authe
along those lines before also, a spoof on
the Linux penguin, Tux.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
---
"The number of UNIX installations has grown to 10, with m
keepers of the Gimp,
and have them run it as one of their monthly contests. The GNOME project
did this, and there were some fabulous logos entered by some very talented
artists.
Brett W. McCoy
http://www.
inister delight...?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
---
"The number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
t; > is entered.
>
> Have you tried doubling up? 'O''Brian'
>
> That is what I have to do in Oracle anyway.
Isn't there an escape character, like the slash?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
ause those that are developing it are doing
> so because they *enjoy* what they are doing, they have a passion for
> it...not because some large company is paying them to do it.
A good point.
Brett W. McCoy
when the SQL postfix came about.
Actually, it was known as Postgres95 originally to differentiate it from
the original Postgres, but as it moved towards SQL compliancy, the SQL
postfix becamse the norm. The full story is in the PostgreSQL
documentation.
Brett W. McCoy
mbered because it is so different from other
databases that are similar (like Medline or other healthcare related
online databases).
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-
On Wed, 22 Jul 1998, Bruce Momjian wrote:
> University Ingres was first, then commercial Ingres was a split-off.
> PostgreSQL is based on University Ingres.
That's what I thought...
Brett W. McCoy
http://www.lan2wan.
On Fri, 24 Jul 1998, The Hermit Hacker wrote:
> Hey, my preference is an elephant. Big, strong, reliable and
> never forgets...
Too many connotations with the GOP...
Brett W. McCoy
http://www.lan2wan.com/~
On Fri, 24 Jul 1998, The Hermit Hacker wrote:
> > Too many connotations with the GOP...
>
> Enlighten me...what is "the GOP"?
Sorry. The US Republican Party, which uses an elephant for their mascot.
Brett W. McCoy
most authors!
You can do multi-column keys in PostgreSQL, I believe, which is
essentially what you would be doing by combining that data into a single
column.
BTW, Alan Watts is a favourite of mine.
Brett W. McCoy
records to patent
records. There's only so much one can normalize.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
---
"The Number of UNIX installations has grown to
rver I've ever used. I've not
used Oracle or Sybase or anything like that, so the only thing I can
compare it with is desktop database systems like MS-Access, and all I can
say is that there' s no comparison. :-) I don't want PostgreSQL to be
like Access, nor anything else
o the databse using the Pg module.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
---
Quantum Mechanics is God's version of "Trust me."
-BEGIN GEEK CODE BLOCK--
with SQL, then do 'select count(*) from ',
you can just read the first (and only) row from THAT query. Can you then
create your cursor from the view?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
---
unction call or by executing an SQL statement), then page through it with
your cursor? Or can cursors not be created from views?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
--
ql LIMITS?
I think it's dependent on the operating system, isn't it?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
---
President Thieu says he'll quit if he doesn'
customer_username, COUNT(*) FROM customerdata
GROUP BY customer_username;
This will give you 2 columns, one with the distinct customer_usernames
and the second with the count of each. The GROUP BY caluse is important
here. This looks like what you wanted in your original query.
Bre
at I would want...
Yep. You can also put the -B as a backend option, but under postmaster,
it still does the shared buffer allocation.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
--
t; connecting to it?
You can run postgres directly without the postmaster, for debugging
purposes. This isn't recommended for regular usage, of course.
Brett W. McCoy
On Sun, 23 May 1999, Bruce Momjian wrote:
> We have a fulltext stuff in the contrib directory.
What's it called? I only see some tcl frontend stuff. Despite my
pessimism form the prior message, I am interested in a full text retrieval
engine.
Brett
o suggest a
> better name?
I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib
directory.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
---
Cabbage,
On Mon, 24 May 1999, Bruce Momjian wrote:
> Sorry, I meant in the distribution's contrib directory, not the ftp
> site. I didn't even know we had a contrib directory on the ftp site.
Wel, you do now! Thanks! I'll check it
Hey, found the module. Looks pretty interesting -- even has the
capability of ignoring stopwords. This is just what I am looking for!
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
umn in target list
I think you want 'select loser, count(*) into losses from moves group by
loser'
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
es
superuser to do it), or the psql command \copy (and you don't need to be
the superuser, but it has some limitations).
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
--
On Tue, 26 Oct 1999, Bruce Momjian wrote:
> I am in the process of writing a book about PostgreSQL for Addison,
> Wesley to be published in 2000.
Cool!
Brett W. McCoy
http://www.lan2wan.com/~
e used in an expression.
I was shocked recently when we put in SQL 7 in our office (we've been
using PostgreSQL for a while now, but we needed SQL 7 to use with a
commercial retrieval system) and needed to start writing functions as I
was used to under PostgreSQL, and couldn't. A b
t me know. I have done some benchmarking with
> the author and he found it pretty fast, usually a few seconds. See the
> section in my book on CLUSTER for information on _why_ it helps.
Thanks, Bruce.
Brett W. McCoy
>
> With the original author, testing was fast, but when he loaded all the
> data, it got very slow. The problem was that as soon as his data
> exceeded the buffer cache, performance became terrible.
How much data are we talking here? H
ith a nightly
cluster.
Brett W. McCoy
http://www.chapelperilous.net
---
Twenty two thousand days.
Twenty two thousand days.
It's not a lot.
It's a
cle.
Brett W. McCoy
http://www.chapelperilous.net
---
QOTD:
"He's on the same bus, but he's sure as hell got a different
ticket."
sk. It's easy to go from a
SQl database to one of the variable-length (or 80 column card image)
text-formats, but not the other way around unless you are into doing some
text-processing programming.
Brett W. McCoy
ays connect to PostgreSQL via MS-Access and generate reports out of
that also.
Brett W. McCoy
http://www.chapelperilous.net
---
If the very old will remembe
94 matches
Mail list logo
