[GENERAL] Exporting Data

[guilherme]

I need to get some information in database and export it.

Is there a way to make PostgreSQL to export one data line to a new file?
Like this:
1 FIRST LINE -- line1.txt;
2 SECOND LINE -- line2.txt;
3 THIRD LINE -- line3.txt
...
and so...

I know that I can import all information into a unique file, but I need to
split that information into severel files.
I've already searched in everything and didn't find a solution.

Can anybody help?

Thanks in advance.



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/Exporting-Data-tp5760108.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Change key primary for key foreign

[Guilherme Rodrigues]

Em terça-feira, 18 de setembro de 2012 17h37min59s UTC-3, Guilherme Rodrigues  
escreveu:
 Hello. I want to change one table already created. Where the comand? thank 
 you.

Ok. Thank All.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Change key primary for key foreign

[Guilherme Rodrigues]

Hello. I want to change one table already created. Where the comand? thank you.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Change key primary for key foreign

[Guilherme Rodrigues]

I created one table so:

CREATE TABLE clima (
city char(80),
cprc int,
);

And have other table so:

CREATE TABLE city (
namechar(80),
other_thing int,
);

But now I want the table clima receive name table city as foreign key. 
understand?
Sorry my bad english.


Em terça-feira, 18 de setembro de 2012 17h37min59s UTC-3, Guilherme Rodrigues  
escreveu:
 Hello. I want to change one table already created. Where the comand? thank 
 you.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] drop table cascade doesn't drop manual sequences

[Guilherme]

Hello folks,

I'm new to postgres and I'm using version 8.1

Here's the problem anyway:

If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.

works


create table bla(id serial);
drop table bla CASCADE;
select * from pg_class were relkind = 'S' = nothing


doesn't


create table bla(id integer);
create sequence bla_id_seq;
alter table bla alter column id set default nextval('bla_id_seq');

drop table bla CASCADE;
select * from pg_class were relkind = 'S' = 'bla_id_seq'


Is this supposed to happen or am I missing something?


Thanks in advance,
Guilherme


---(end of broadcast)---
TIP 6: explain analyze is your friend

[GENERAL] I want to unsubscribe, how can i do it?

[Guilherme Fortunato]

Tha is it! What I want to know is in this messages's subject.

Thanks

--
Guilherme Fortunato
e-mail: [EMAIL PROTECTED]
--

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] I want to unsubscribe!

[Guilherme Fortunato]

--
Guilherme Fortunato
e-mail: [EMAIL PROTECTED]
--

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]