Re: [GENERAL] Web-based PSQL?

Hello Stan, On 29-Mar-00 06:33:32, you wrote: >I know this has a standard SQL interface, but I was wondering if there was >an existing web app that let you show schemas, create tables, edit data, >and all of that from one simple interface. Does PHP provide this? Sorry >for my confusing questio

Re: [GENERAL] doing backups

Jeff MacDonald writes: > i think the postgres user should have acess to all databases no matter > what. I disagree. Firstly, for the backend to actually know that you're the postgres (Unix) user it would have to authenticate you, using ident or kerberos perhaps. But in the case in question the p

[GENERAL] "cannot create TABLE_NAME" error

When I try to create a table and it already exists, I get the error: "relation 'TABLE_NAME' already exists". However, I tried to create a table like this: CREATE table alpx_ (word text not null, field text not null, expDate date, postingId int4 not null, mall text not null, sellBuy text not null,

[GENERAL] SQL Special Characters

Can anyone point me to a list of the special characters for SQL strings? Ie, when I do a WHERE textstring = '12%' the % is a special character, and has to be escaped with a backslash. I'm looking for a list of all such characters. The ones I know of are ', \, and %, but I'm sure that th

[GENERAL] to SQL or not?

Hello folks! I have been working with a client that has the need to access a large database via web form query. The current database is just over 1 Gbyte, with about 1 M records. Each record contains approx 200 fields, and the query form may submit up to 50 fields for search. We expect the dat

[GENERAL] replication

Can postgres handle replication? In Oracle there is the ability to do snapshots and have these snapshots on other machines stay up todate due to the snapshot refreshes. Are there any replication or distributed database pieces to postgres? than you so much for your response before hand. Jenif

[GENERAL] VxWorks

Does PostgreSQL currently run on VxWorks?

[GENERAL] \i - users

hi , i'm trying to import a database with teh \i command from a pg_dump. as a regular user i get lots of errors regarding max query length exceeded . however if i run it as pgsql i don't get the error. problem comes in because these tables must be owned by the regular user and not pgsql Jeff

Re: [GENERAL] Functions in postgres

On Wed, Apr 05, 2000 at 12:04:49PM -0500, Victor Manuel Jaquez Leal wrote: > > Hi! Hi back at ya. > > I know that with \df you can see the functions available in postgres, but > there must be others not documented just like getpgusername(). > > My question is if are there a more complete list

Re: [GENERAL] Functions in postgres

Ah, I forget to mention how to compile the code I sent. I use: gcc -fPIC -shared -I /usr/local/pgsql/include -L /usr/local/pgsql/lib -o sqlcrypt.so sqlcrypt.c then move the sqlcrypt.so file into my pgsql storage space. This is on Linux, if it matters. Ross -- Ross J. Reedstrom, Ph.D., <[E

[GENERAL] System tables

Hi all: Is there any document that describes the system tables of Postgres (the pg_* ones), their function, utility, relations among each other, etc., and how can one manipulate them to recover from errors? I am asking this because I've just experienced one of those awful database

[GENERAL] PostgreSQL Emulation

I'm starting an interesting project for my company. We have a large, complex proprietary legacy database with a considerable suite of backend software that maintains it. The client applications are NT-based and access these flat files through Windows Networking or Netware. Our mission is to

Re: [GENERAL] Web-based PSQL?

I've now developed a basic web-based interface to psql (CGI in PERL). It is quite basic, and at the moment does not report errors from psql properly, but it could be quite handy in some circumstances. I've no doubt there are better ways of doing a number of things in it, too! Of course, allowing

[GENERAL] Functions in postgres

Hi! I know that with \df you can see the functions available in postgres, but there must be others not documented just like getpgusername(). My question is if are there a more complete list of postgres' functions. To be more specific I'm looking for a crypt function. BTW How do I implement a

[GENERAL] Problem report (dropping views that are called by other views)

I'm using PostgreSQL 6.5.3 on a FreeBSD 3.4-STABLE box (all you linux postgresql users out there, switch to freebsd already!). I had created a View A, based on an existing View B. When I dropped View B and re-created it one day, the View A did not get deleted, but as soon I went to use A again

Re: [GENERAL] shell scripting

On Tue, 4 Apr 2000, Marc Tardif wrote: > Is ther any way to foresee if a database exists or if a user has > permission to read/write a database from within a shell script? The best (and as far as I know the only) way to determine whether you have access to something is to try to access it. Anyth