SEO

#1 (**permalink**) 04-09-2008, 06:12 PM

Hi All,

I have eliminated certain tables while exporting as the size of the data in
the tables are huge.Though am having the schema which contains all the
tables.

Now I want to import limited set of records/rows ( 1000 tuples ) from the
eliminated tables.

Is this possible? If yes, please tell me how to accomplish this?

Secondly, like to know how postgresql take care of all the
constraints/referential integrity while importing the records from the
different tables?

Cheers,
Cha
--
View this message in context: http://www.nabble.com/importing-limi...html#a11392319
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-09-2008, 06:12 PM

Hi,

Le lundi 02 juillet 2007, cha a écrit*:
> Now I want to import limited set of records/rows ( 1000 tuples ) from the
> eliminated tables.
>
> Is this possible? If yes, please tell me how to accomplish this?

If you have CSV or CSV-like data file format, you can use pgloader with the-C
option, you can even load from any line in the file (given by number or data
id, multi-column keys supported) :
http://pgfoundry.org/projects/pgloader

Regards,
--
dim

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBGiPKXlBXRlnbh1bkRAkDrAKCaOQkS+PzSPwc9AMf6rs 1D+6bzBQCgvn5/
Y8zx5aiEXtKwkA4kSOptuRY=
=M9ku
-----END PGP SIGNATURE-----

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

importing limited set of rows/tuples