There is a SELECT INTO, however it is used for a different purpose than the
one I believe you require.
For your purposes,
INSERT INTO
table_name( field1,
field2,
fieldn )
SELECT
field1,
field2,
"default"
FROM
Kenneth Lareau <[EMAIL PROTECTED]> writes:
> I'm not certain what additional information might be helpful, but I'm
> using gcc 2.95.2 to build, and here is my configure line:
Try 2.95.3 --- another person reported that PG worked a lot better on
Solaris after he updated gcc.
Hi,
I am a new postgre user. I had used sql commands to
create database and tables. Is it possible to create a script or installable
version on existing database which I could run on any machine and it would
crearte the database with all the tables and everything. Can anyone please help
me w
I am running into a serious issue getting PostgreSQL 7.1.1 to work
on my Solaris 7 system (Ultra 10). I've been able to build everything
fine, but I've tried multiple times to run the tests (make check) and
have nearly all the tests fail, though not always the same ones each
time.
Checking the '
Hellow
I'd like to know if it is possible to select data from a db on a server
and then to insert it on an other server ?
Is there somth like
SELECT * INTO backup FROM server.database.table;
???
Is there an alternate solution ?
Good day,
/joel francken
Belgium
---(
Does anyone have any idea on a simple startup script for the postmaster on
Slackware? I have looked around, and found RedHat examples, but they do not
work on Slackware, and I am not familiar enough with Bash scripting to port
them over. I have installed Postgres 7.0.2 from source off the Postgr
Title: upgrading from 7.0 -> 7.1
I just did apt-get install postgresql postgresql-client on my debian/unstable.
Now i cant get postgres to start again.
I followed the instructions and played with postgresql-dump, and sure it dumps my stuff
but using -d -p doesn't to anything.
How do i co
