'EnterpriseDB Management Server' (
http://www.enterprisedb.com/products/enterprisedb_mgmtsvr.do) can be a good
option as with your requirements
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/27/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote:
On 12/27/06,
Is there any way to make a dump from a query?
For example if my query is:
select field1,field2 from table
Does it exist a shell command like pg_dump --QUERY myquery -f myfile?
Have a nice day
Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-billionaire by now
Hi Enrico,
The following command will get you a text file of your result-set:
# echo "SELECT customer_id, first_name, sur_name FROM
users;"|/usr/local/pgsql/bin/psql -U [username] -d [database] > myfile.txt
# cat myfile.txt
customer_id | first_name | sur_name
-++--
You can use the COPY (
http://www.postgresql.org/docs/current/static/sql-copy.html) command for
doing so
An example will be -->
COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO
'/usr1/proj/bray/sql/a_list_countries.copy';
-
Shoaib Mir
EnterpriseDB (www.enterp
Andy Shellam (Mailing Lists) wrote:
Hi Enrico,
The following command will get you a text file of your result-set:
# echo "SELECT customer_id, first_name, sur_name FROM
users;"|/usr/local/pgsql/bin/psql -U [username] -d [database] > myfile.txt
# cat myfile.txt
Alternative version:
psql -d
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> tradein_clients=> \o db.lst
> tradein_clients=> \l (till this point, there is nothing in file db.lst)
> tradein_clients=> \q (now it saves) (also saves if another \o is issued)
> Dunno till what extent this behavior is justified.
I wasn't too e
I hv some data in excel which needs to be imported into PostgreSQL.
I am using PgAdmin III to access the PostgreSQL database
Can anyone pleease guide me in this .. ?? I am mew to PostgreSQL.
Thanks in advance
---(end of broadcast)---
TIP 1: if post
Negandhi, Nishith wrote:
> I hv some data in excel which needs to be imported into PostgreSQL.
> I am using PgAdmin III to access the PostgreSQL database
> Can anyone pleease guide me in this .. ?? I am mew to PostgreSQL.
Export from excell as comman-delimmited. PostgreSQL can load that.
--
On Wed, 2006-12-27 at 12:17 -0500, Bruce Momjian wrote:
> Negandhi, Nishith wrote:
> > I hv some data in excel which needs to be imported into PostgreSQL.
> > I am using PgAdmin III to access the PostgreSQL database
> > Can anyone pleease guide me in this .. ?? I am mew to PostgreSQL.
>
> Export
On 12/27/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> tradein_clients=> \o db.lst
> tradein_clients=> \l (till this point, there is nothing in file db.lst)
> tradein_clients=> \q (now it saves) (also saves if another \o is issued)
> Dunno till wha
On Wed, Dec 27, 2006 at 14:05:30 +0100,
Enrico <[EMAIL PROTECTED]> wrote:
> Is there any way to make a dump from a query?
>
> For example if my query is:
>
> select field1,field2 from table
>
> Does it exist a shell command like pg_dump --QUERY myquery -f myfile?
In 8.2 you can use a query wi
Another thing to watch out for when upgrading to 8.2.0:
I had some 8.1.x databases with restricted rights, like REVOKE CREATE ON
DATABASE. After pg_dumpall and reload into 8.2.0, I lost CONNECT rights on
those databases. So only the superuser account can connect. The reason
seems to be that my du
Something to watch out for when upgrading to 8.2.0:
My server start command for 8.1.5 and many prior releases:
$ postmaster -D /opt/postgres/data -S -i
Try it at 8.2.0:
$ postmaster -D /opt/postgres/data -S -i
FATAL: parameter "work_mem" requires an integer value
Reason: 'postmaster' an
L Bayuk <[EMAIL PROTECTED]> writes:
> Another thing to watch out for when upgrading to 8.2.0:
> I had some 8.1.x databases with restricted rights, like REVOKE CREATE ON
> DATABASE. After pg_dumpall and reload into 8.2.0, I lost CONNECT rights on
> those databases. So only the superuser account can
L Bayuk <[EMAIL PROTECTED]> writes:
> postmaster -S used to mean: silent mode. Now it means: Set
> memory used for sorting. Unfortunately, the reference manual still
> documents the old meaning for -S (PostgreSQL Server Applications, postgres
> command, -S option).
Hmmm ... Peter, is this a docume
15 matches
Mail list logo
