Bookmarks
Account
ACL
Tools
New
Other
New Table: Store & Export
If we assume that you have many records in your Table, you will at some point have a need to either Store those values -- or -- Export those Values. Store & Export are two of the simpler alternatives.
Store is also called (in PostgreSQL circles) a Snapshot. Click Store and a file is created that you can download to your Desktop. What is interesting about this Snapshot is that it is not only the data - it also contains the 'instructions' about the Structure of the file. If you send it to another PostgreSQL user, they will be able to instantiate the entire Table with Structure AND Data.
Store is also called (in PostgreSQL circles) a Snapshot. Click Store and a file is created that you can download to your Desktop. What is interesting about this Snapshot is that it is not only the data - it also contains the 'instructions' about the Structure of the file. If you send it to another PostgreSQL user, they will be able to instantiate the entire Table with Structure AND Data.
Store (Create Snapshot) can be a handy means of Archiving or Sharing an entire Table.
Export allows you to be more selective - and only the data you choose is exported, not the Structure. You can Export selected columns from within a Table as CSV (Comma Separated Values, xml or xls.
See the Screenshots below.
Export allows you to be more selective - and only the data you choose is exported, not the Structure. You can Export selected columns from within a Table as CSV (Comma Separated Values, xml or xls.
See the Screenshots below.
Click Store to create & Download a Table Snapshot (Data & Structure)
Click Export to selectively export columns of data. More below.
If you had Clicked Export for this Table, you would see:
CSV is general usage for "separated".Additional options include xml or xls
comma, |, : (pretty much 'whatever')
Don't want a Column exported? Select it and click Remove.
Want to Change the order of Export? Select the column, then click Up or Down until it is in the order you prefer.
Want to Change the order of Export? Select the column, then click Up or Down until it is in the order you prefer.
When ready, Click Export. Will Download to your Desktop.
New TableStoreExport
2
1
3
4
5
6
7
8
9
10
11
New Table
Name Describe
Add Columns
DataTypes
TableStructure
TableOptions
DataEntry
ImportData
StoreExport
AddConstraints
Indexes Keys