[GENERAL] How to store variable data in a field?

Hi all, I need to create a table to store Twitter accounts information, Facebook and other social networks details for API login. I need to know if it is possible to store the account details(account_details field) in a field that contains something like an array. I need to store this data in an

Re: [GENERAL] How to store variable data in a field?

Andre Lopes, 21.02.2012 16:11: Hi all, I need to create a table to store Twitter accounts information, Facebook and other social networks details for API login. I need to know if it is possible to store the account details(account_details field) in a field that contains something like an array.

Re: [GENERAL] How to store variable data in a field?

Hi, I am going to start with quotation: *PostgreSQL is a powerful, open source object-relational database system.* So let's use objects (TYPES): First You have to create proper types: CREATE TYPE Facebook AS (account_name text, fb_special_hash text, fb_security_hash text,