[GENERAL] Exporting Data
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
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
Re: [GENERAL] Change key primary for key foreign
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] Change key primary for key foreign
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
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!
-- Guilherme Fortunato e-mail: [EMAIL PROTECTED] -- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] I want to unsubscribe, how can i do it?
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]